Is it possible to use dynamic query in power BI service?

[mingchao]

I would like to know if it is possible for the user to dynamically refresh the data in our report by changing certain parameters in the website when we published the report to the PowerBI service.  I know this can be achieved on the PowerBI desk, but is it also possible on the PowerBI service?

[Anonymous · Accepted solution]

Hi, @mingchao 

Dynamic queries are fully supported in Power BI Desktop, but are not currently supported on the Power BI service, with limitations. On the Power BI service, you can only change the data for parameters, not create parameters.

And if it's Any and Binary type parameters, then on the Power BI service the parameters are grayed out and can't be used.

You can learn more from the following link:

Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.