Dynamic M query parameters on Power Bi Report Server

[romina80]

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

[v-pnaroju-msft · Accepted solution]

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.

Additionally, please refer to the links below:
Compare Power BI Report Server and the Power BI service - Power BI | Microsoft Learn
DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn

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]

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]

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

[romina80]

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