Dynamic Parameter

[AnilJang]

Hi All , 

  Please provide me solution if any one faces the issue.

I had created the report with direct query and dynamic parmeters which are binded to few dimenssions table.The report is working fine from Power BI desktop, But when I publisehd the report to Power BI service only the dimenssions tables are loading the visuals whcih are loaded by stored proceudres which are configured with dynamic parmetes are failing.Any once faces the similar issues

[v-luwang-msft]

Hi @AnilJang ,

The error you encountered is? Can you share a screenshot of the error or specific error message?

Best Regards

Lucien

[AnilJang]

Hi Lucien, 

Thanks fore the reply .There is no specific error.

I created the report with dynamic paramters with dynamic sql query. The report is working fine in desktop version but when i publish the report to power bi service the queries with no dynamic paramters qre loading fine but other queries are failing which are configured with dynamic parmaters.

I think at power bi service , Direct sql queries with dynamic paramters will not work.Please let me know.