Forum Discussion

romina80's avatar
romina80
Frequent Visitor
10 months ago
Solved

Dynamic M query parameters on Power Bi Report Server

Hello,

I need to build some reports with Direct Query and pass some parameter to the query.

I'm using Power Bi Desktop (Report Server) and I don't see any solution to bind the parameter to a slicer (No option available in the parameter setting or in the advanced properties of a table field).

I don't know if I'm doing something wrong but it looks like the parameters cannot be used on Report Server.

If it so, is there another way to run direct queries with filters and show data in a simple visual?

 

Thanks

Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    10 months ago

    Thankyou, Jihwan_Kim, for your response.

    Hi romina80,

    We appreciate your inquiry through the Microsoft Fabric Community Forum.

    Based on my understanding, Dynamic M Query parameters are presently not supported in Power BI Report Server. Consequently, you are unable to bind a parameter to a slicer or use it with DirectQuery in Report Server. This feature is available only in Power BI Service and in Power BI Desktop (for Service) versions. Power BI Report Server does not include the newer modeling capabilities, such as Dynamic M Query parameters, that are available in the Power BI Service environment.

    Please consider the following workaround approaches, which may help resolve the issue:
    1. Filters and slicers in DirectQuery mode automatically push predicates to the data source, thereby enabling parameter like filtering behavior without M parameters.
    2. If Dynamic M parameters are essential, create and publish the report to the Power BI Service, where the feature is fully supported.

     
    We hope the information provided assists in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
    Thank you.

     

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    10 months ago

    Hi,

    I am not sure if I understood your question correctly, but please try loading two tables into the report.

    And then, based on the selection from the slicer on the report, different result can be shown.

    Please check the below picture and the attached pbix file. I tried to create a sample pbix file like below.

    It is not direct query mode, but I hope you can get the point. Or, please let me know if I missunderstood.

    Thank you.

     

     

    In this sample, I tried to use field parameter feature in Power BI.

    Use report readers to change visuals - Power BI | Microsoft Learn

     

     

     

     

    • romina80's avatar
      romina80
      Frequent Visitor
      10 months ago

      Hi Jihwan_Kim ,

      thansk for your feedback.

      Unfortunately I'm not able to open your file because I receive this message: 'Report contains enhanced report format (PBIR). Please make sure the PBIR preview feature "Store reports using PBIR format" is enabled and try again.'

      I checked in the 'Options and Settings' but I don't find the 'Preview features' option to enable that.

      I'm using Power Bi Report Server Desktop (version 2.138.2255.0 64-bit (January 2025))

      Regards

    • romina80's avatar
      romina80
      Frequent Visitor
      10 months ago

      Hi Jihwan_Kim ,

      I think I found what is the real issue with my model.

      I followed the steps in this topisc: desktop-dynamic-m-query-parameters 

      When I try to bind the startdate field to the parameter I don't have the option 'Bind to parameter' that should be available in the Advanced option of the field. 

      Thanks

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    10 months ago

    Thankyou, Jihwan_Kim, for your response.

    Hi romina80,

    We appreciate your inquiry through the Microsoft Fabric Community Forum.

    Based on my understanding, Dynamic M Query parameters are presently not supported in Power BI Report Server. Consequently, you are unable to bind a parameter to a slicer or use it with DirectQuery in Report Server. This feature is available only in Power BI Service and in Power BI Desktop (for Service) versions. Power BI Report Server does not include the newer modeling capabilities, such as Dynamic M Query parameters, that are available in the Power BI Service environment.

    Please consider the following workaround approaches, which may help resolve the issue:
    1. Filters and slicers in DirectQuery mode automatically push predicates to the data source, thereby enabling parameter like filtering behavior without M parameters.
    2. If Dynamic M parameters are essential, create and publish the report to the Power BI Service, where the feature is fully supported.

     
    We hope the information provided assists in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
    Thank you.