We have few reports which we need to develop in Power BI using existing stored procedures. I want to understand if it works the same way as in SOL Server Reporting Services.
For E.g.In SOL Server Reporting Services ,We pass parameter values(single/multiple-select) to the main stored procedure. The Store procedure takes these parameters as input and displays the output on the report. Does it work the same way with slicers in Power BI?
You may take a look at Deep-dive into query performance with SQL Profiler and Power BI Desktop.