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)
Advocate IThanks a lot for the clarification ,
Just to ensure I understand correctly the below statement -
No, it is not necessary, you can do it with multidimensional too. I am not sure about embeded power BI models - need to test. Regarding to SQL direct queries and RLS, this is in preview, so I believe that it works only on the cloud
So does it mean Direct Query to SQL database and RLS is not supported in the latest release of Power BI report server , If that is the case we can not use it as we have requirement for both direct query and RLS
Resolver IINo 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)