Passing Parameters to Power BI through Stored Procedure

[v-kumdee]

There Should be Provision of passing the Parameter to the report like we do in SSRS Reports. There should be any method to execute Stored Procedure by passing the Parameters

[fbcideas_migusr]

This would be handy to have. Currently I need to create view via Table Valued UDF and query the view.

[sudarshan]

This is absolutely essential, I am not sure why this has not been done till now

[eugene_harvey]

It would be great to know if this is in the pipeline or something being considered as it is the one thing holding back the use of PowerBI as a proper enterprise reporting solution in the same manner that SSRS is. The functionality is all there to embed PowerBI Models into an ASP.NET application through the use of URL strings, similar to using the SSRS ReportViewer Control, but unlike the SSRS Report Viewer Control, you can't pass parameters to the behind SQL query for PowerBI which enables query driven row level security routines, whether stored procedure or not. Using parameter collections to pass to the PowerBI query would greatly improve efficiency and performance as on the data required by the user is returned. Ideally I would like to use all PowerBI Models in Direct Query mode where the ASP.Net application user is identified and only data for that user is returned, even a single parameter would help where the User Credential is passed to the SQL Query.

[dineshkumar]

​@Rose Spitzer Is there any update on this feature? Please let us know!

[marcoz1]

Cant believe by now it still not possible to use slicers and pass the value to parameter.

[gary_thomann1]

Lol. Vote on all the duplicate threads as per below. 'the noisy wheel...' Every other reporting platform can do it! Even my Grandma can do it 🙂

[lobal]

This is badly needed for handling reports with large volumes of data. I've had to decrease report efficiency just to use Power BI.

[nks1]

fix the damn thing already....been waiting for this for over a year now ......!?!?!?!? We have a lot of customers on standby on this feature!

[ganatechnology]

this is badly needed as power bi we should be moving forward and not back wards.. hi dev team i know you guys try to bring features every month. not sure why this critical basic requirement is still not in power BI as this has been raised since 2015!! in this forum .. Also multiple result set to return from SP to handle via power bi .. SSRS legacy has all this but not in power BI!!.. dev team could you seriously look into this. Thanks nathan

[paul_cornett]

Can't believe this isn't a feature since it has been in SSRS for years.