Forum Discussion
Embed Power BI report in web application using Power BI Report Server
Can anybody tell me if I use the on-premise power BI report server option , will I be able to to embed reports into my internal web application ?
No and Yes, I will explain:
NO: So far, you cannot use the Power BI role feature for implementing a RLS to filter direct query using the report services
...BUT...
YES: if you have implemented the RLS in the data source (ie: using views that filter the data that the user can see), and your data source are these views. Remember to keep Windows integrated security on the data sources - you may have to configure kerberos delegation if the database is not on the same server as the report server - but this is expected.
(I hope you got it and set this as the answer - because it took me some time testing...heheh)
11 Replies
Yes, using an IFrame and setting "?rsembed=true" appended to end of URL.
Okay , but can I build a solution within Power BI Report Server so that the embedded content shown on the reports need to vary according to the user role (District Manager , Area Manager etc) ,
My client does not want the users to explicitly log-in to Power BI , they will log-in to the internal application where the power BI report will be embedded , Login will use the windows AD authentication.
But user will not log-in explicitly to Power BI , there needs to be some connection string passed to Power BI from the application that will tell Power BI who the user who logged in to the application and viewing the report.
Not all users will have access to all the reports , neither all have access to all the data ,
Please suggest if this kind of solution can be built using Power BI Report Server on premises
I know this can be buit in Power BI report services using Power BI embedded license , but need to check the same can be done with the on-premises solution , if can not be done , then on-premise solution of power BI is of no use to us at this point
Hello jimmymitra,
Yes, it can be done!
by default, the Power BI Report Server uses windows authentication, so the users are not prompted for logins.
You can filter the data by the Username() functin using the RLS (Row Level Security) feature of the tabular model, and make a live connection of your power BI reports to the Tabular. In my point of view, this is the best approach for your problem ;)
got it working in our environment
append
?rs:embed=true
BOOM!
- I suggest that you create another topic and add more details about how your application authentication works. Does it uses integrated windows authentication?
Hello Jimmy,
I know this post is old but we have the same requirement now. Where you able to achieve your requirements? It is not just about the embed=true query string. In our case, the user needs to be able to navigate the power bi report server folders and reports. Where you able to read the folders/reports using some kind of api and then filter the ones that the user has access to while hiding the others?
