Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Community,
I'm encountering an issue with M query parameters in Power BI Report Server. The setup works perfectly with PostgreSQL and report server and also functions correctly on Power BI Desktop for report server when using SQL Server. However, when I publish the report to Power BI Report Server, it fails to work.
Here's an example of the dynamic M query I'm using:
Has anyone faced a similar issue or can provide insights on why dynamic M query parameters might not work with SQL Server on Power BI Report Server? Any suggestions on additional steps to troubleshoot or resolve this issue would be greatly appreciated.
Thanks in advance!
Solved! Go to Solution.
Hi @VarunDC ,
Dynamic M query parameters can not work with SQL Server on Power BI Report Server.
Below is the official link will help you:
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @VarunDC ,
Ask what connection mode you are using, if you are using direct query mode, test it directly in Power BI Desktop. Make sure that the dynamic M query parameters work as expected there.
If so, the issue may be specific to the Power BI Reporting Server environment.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Yes I am encountering an issue with the Direct Query mode. While it works as expected in Power BI Desktop, the filter value is not being passed to the parameter when I publish the report to Power BI Report Server. Could you please assist in resolving this discrepancy?
Thanks in advance
Hi @VarunDC ,
Dynamic M query parameters can not work with SQL Server on Power BI Report Server.
Below is the official link will help you:
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.