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

     

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 ,

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