Michael Oseni

Michael Oseni

  • NA
  • 2
  • 1.2k

Dynamic Power BI reports using Stored Procedures Parameters

Nov 14 2018 6:40 AM

I am trying to create a Dynamic Power BI report using SQL Server Stored Procedures with Parameters. My questions (1) Can I use DirectQuery instead of Import for my Data Connectivity mode. (2) How can I pass the value from a slicer to the stored procedure parameter in Power BI and get the data to be refreshed in the Power BI Reports.

I will like to hear a reply from

Dhruvin Shah

Regards

Michael


 


Answers (2)