Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
How to provide row level security to SQL Server and this security connect to power bi desktop?
Thanks
sreenivasa
Hi @kunuthuri,
How do you connect with the data source? There are three ways: Import, DirectQuery, Live connection.
There are two scenarios about setting Row level Security in Power BI about SQL Server.
1. If you connect the data source with import or Direct query , you could create Roles in Power BI Desktop under the Modeling, Manage Roles.
For this scenario, you could refer to Dynamic Row Level Security and Row-level security (RLS) with Power BI.
2. If you work with Analysis Services Tabular model in Live connection, you should create roles in the tabular model, the detail steps you could refer to Dynamic row level security with Analysis services tabular model and this article.
Best Regards,
Cherry
Hi @v-piga-msft
Beyond the two scenarios that you described, could I connect my Power BI Desktop to a SQL database with RLS trough an SSAS model? I would like to know if I can use the impersonation on SSAS to get and pass the user to the database and filter the data according to my RLS rules.
Thank you,
Fred
So, 4 years later... did you fint a solution to this?
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |