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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • 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.