Forum Discussion

AnilJang's avatar
AnilJang
Frequent Visitor
3 years ago

Dynamic Parameter

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

 

Need Help

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    Hi AnilJang ,

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

     

     

    Best Regards

    Lucien

    • AnilJang's avatar
      AnilJang
      Frequent Visitor
      3 years ago

      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.