Forum Discussion

VarunDC's avatar
VarunDC
Regular Visitor
2 years ago
Solved

Dynamic M Query Parameters Work in PostgreSQL but Not in SQL Server on Power BI Report Server

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 De...
"Power BI Report Server "
Query Parameter
VarunDC's avatar
VarunDC
Regular Visitor
2 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.