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
Rohit MishraPosted Oct 29, 2020, 8:53 AM
Sourav MukherjeePosted Dec 6, 2018, 8:46 PM