Forum Discussion
Using a Power BI Dataset Store Procedure with Parameters, but Using the DataSet in Paginated Report
This is the issue. We are converting from SSRS which uses Shared datasets. The data set is a parameterized stored procedure. We want to create a PBI dataset that contains the parameterized stored procedure. However, we want to be able to pass the dataset a parameter from the paginated report. In SSRS its simple, but trying to create the same flow in PBI is not. Any help would be appreciated.
3 Replies
PresleyHunter , In power bi only Dynamic M parameter can do that in case of power query
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
I have setup the dataset using M with parameters. The issue is how do I pass the paramter from Paginated Reports to the Power BI Dataset. For example: I have stored procedure dbo.dosomething(reportnum) this is what the Dataset is using. I need to be able to pass reportnum from paginated report, to run the dbo.dosomething procedure, in the PBI dataset.
PresleyHunter, I am facing the same issue where I need to pass-on parameters from Paginated Report to the Power BI Dataset parameters. Did you manage to resolve this issue?
My PowerBI Dataset is based on few tables and Stored Procedures (which takes few parameters as input) to spit out the results. I have managed to generate the Dataset with Parameters. However, struggling to bind the same Paginated report parameters to the same matching Power BI Dataset parameters.
Anyone .. please help?
