Forum Discussion
Advocate IEmbed Power BI report in web application using Power BI Report Server
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)
Microsoft EmployeeYes, using an IFrame and setting "?rsembed=true" appended to end of URL.
jimmymitraOkay , 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
muchinskiResolver II
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 ;)
- jimmymitra
Is it necessary to use tabular model , we are not using SSAS tabular , instead planning to use the Power BI Modelling and direct query to SQL.
I am concerned there might be some challenges with Power BI Report Server ,
And since anyway Premium license is required for this , then why not use more conventional solution -like power BI service in the azure
gemidriverHelper II
got it working in our environment
append
?rs:embed=true
BOOM!
- muchinskiI suggest that you create another topic and add more details about how your application authentication works. Does it uses integrated windows authentication?