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.
The one and only thing holding back using PowerBI as an enterprise reporting solution for multiple users with PowerBI embedded in an ASP.Net Solution is the inability to pass parameters via the URL to the query behind in the PowerBI Model in that same manner you can do it in SSRS. PowerBI is a much better UI with UI interaction that SSRS, but we are stuck with SSRS until similar functionality is made available. It is such a shame as we would migrate many of our SSRS RDL's to PowerBI Model deployed under Power BI Report Server.
It must be coming as Power BI Report Server which has superseded SSRS Report Server.
This is desperately needed so as to create robust and efficient on-premise deployable .NET solutions. We have created a web based Analytics solution embedding SSRS Reports using the Report Viewer control. Using the ASP.Net Application front end to collect parameters, these are passed to SSRS Report via the Report Viewer Control to populate the SSRS Template, with the parameters then passed to the SQL Query behind the SSRS Report.
With Power BI being able to be launched in an iframe in our ASP.Net app, we really need a means to pass parameters to the Power BI Model which can be used in the query behind (primarily Direct Query) so that the SQL Query will return only the results based on the parameters. The current option of passing Filter Options to the already populated Power BI is not sufficient in terms of both performance and user based security.