Energy Question is a robust device throughout the Microsoft Material surroundings, enabling customers to handle information sources and rework information effectively. Nonetheless, a typical problem you might face is that after publishing the Semantic Mannequin, the Energy Question parameters both don’t seem or are greyed out, making them non-editable. On this put up and its accompanying YouTube video, I’ll stroll you thru the steps to diagnose and repair these issues, guaranteeing that your parameters work as anticipated in your printed semantic fashions.

Why Do Energy Question Parameters Grow to be Unavailable?

There are just a few the reason why your Energy Question parameters won’t seem or be editable after you’ve printed your report back to Microsoft Material. These points usually relate to both the way in which the parameters are arrange inside Energy Question in Energy BI Desktop or how they work together with the information sources.

Frequent Trigger and Repair

1. Parameter Knowledge Kind in Energy Question

Some of the frequent causes your parameters could be greyed out or non-editable is as a result of parameters’ information varieties outlined in Energy Question inside Energy BI Desktop. In case your parameters are of sort any, then they received’t present up, or they’re read-only (greyed out). The fixation is straightforward:

• Open Energy Question Editor in Energy BI Desktop.
• Click on Handle Parameters.
• Guarantee the right information sort is outlined for the parameters.

2. Incremental Refresh Parameters

One other potential problem is expounded to incremental refresh parameters. When implementing Incremental Knowledge Refresh, we should create two parameters with particular names: RangeStart and RangeEnd. These names are reserved and can’t be used for something apart from implementing Incremental Knowledge Refresh. These two parameters will likely be hidden in Microsoft Material after being printed.

In case you are all for studying extra about implementing Incremental Knowledge Refresh in Energy BI, I’ve printed a number of blogs about this subject previously:

Study Extra

If you wish to dive deeper into working with Energy Question parameters, I’ve written an in depth weblog collection overlaying this subject extensively. You could find the weblog collection right here:

• Energy BI Desktop Question Parameters, Half 1, Introduction
• Energy BI Desktop Question Parameters, Part2, Dynamic Knowledge Masking and Question Parameters
• Energy BI Desktop Question Parameters, Half 3, Record Output
• Fast Suggestions, Energy BI Desktop, Question Parameters, Half 4, Passing Energy Question Parameter Values to SQL Server Saved Procedures

Moreover, I’ve additionally lined Question Parameters in Chapter 3, Knowledge Preparation in Energy Question Editor in my ebook, Knowledgeable Knowledge Modelling with Energy BI, 2nd Version. In the event you’re , you should purchase the ebook right here.

Conclusion

Coping with Energy Question parameters not showing or being non-editable will be irritating, however with the best troubleshooting steps, you may resolve these points and make sure that your experiences work as meant. Comply with the guidelines outlined above, and you must be capable to get your parameters functioning correctly very quickly.

As at all times, don’t forget to subscribe and go away your feedback beneath.

Comply with me on LinkedIn, YouTube, and @_SoheilBakhshi on X (previously Twitter).