Forum Discussion

mwilliams88's avatar
mwilliams88
Regular Visitor
3 years ago

Dynamic Parameter not updating

Hello,   I have a simple report using a dynamic parameter with DirectQuery that works locally on Power BI Desktop for RS, and also works on the Power BI Service with gateway.  On the report server,...
dynamic parameters
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

Short answer is that I believe this is by design, not a bug.

Unfortunately not every feature that works in the service is supported in the on-prem Report Server. If you check here https://learn.microsoft.com/en-us/power-bi/report-server/compare-report-server-service it says that Dynamic M Parameters are not supported on Report Server. In fact Desktop for RS should not let you configure this option. Did you create the report in Desktop for RS or was it originally created in a service version of Desktop?

 

So if you really need Dynamic M Parameters then publishing your report on the service and using a gateway is currently the only supported option.