Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please could you tell me how to use SSAS Tabular 2016 with Dynamic RLS as a data source for PBRS?
I have more than a thousand of users with their logins and respective security level in a table. Each users have acess to a specific numbers of files in the database and are not allowed to see each others case files (GDPR/Data protection rules). In the meantime we also have people that manage other people and that can look at their subordinate cases.
In the past, we solved this problem by using SSRS: we would use SQL statement that would include the Userlogin as a parameter to filter a security table.
We would like to reproduce this model using Power BI reporting server.
I have tried several solutions:
The last solution, would be my prefered if the 2 issues described above could be avoided.
Hi,
Could you please share us the steps the for the RLS issue filtering.
We are aslo same issue
Thanks ,
Suresh
Hi @Anonymous,
Please refer to jtarquino's reply in this thread. After configuring RLS on resource side, and publishing reports to Power BI report server, set the data source credential to "As the user viewing the report".
Regards,
Yuliana Gu
Hi @v-yulgu-msft,
Thank you for answering me. I have already done these steps. I wrote before, Direct Query to a SQL statement is not a viable solution because of the amount of the data. I always use the "As the user viewing the report". But for SSAS, this option doesn't filters the rows according to the role included into SSAS Tabular. I was wondering if there is a keyword that I need to use in the connection string to let the SSAS Tabular knows that I want to use the role that I have created?
Lets say that you have created a SSAS Tabular (let's call it a "cube") with Role1 that filter using a certain logic and Role2 taht filters using a different logic. How would you tell Power BI to select Role1 for example? Am I misunderstanding something?
@Anonymous did you find a solution for this?
@vmn0620: Nope. I have contacted directly several members of Microsoft and noone knows to achieve that. They assume that Report Server Power BI recognises the roles created in SSAS when actually it doesn't. Quite frustrating to be frank. You can get a SSRS report on a PBRS to recognise the roles (using the connection string keyword "role") or even Excel to recognise it, but not Power BI.
Has this resolved in the new version of PowerBI? Can PowerBI recognise the SSAS Roles?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
8 | |
2 | |
2 | |
2 |
User | Count |
---|---|
15 | |
11 | |
4 | |
2 | |
2 |