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.
Hello,
I want to segregate data in Power BI report server. The database is an Access database.
"User 1 can only view the Perimeter" , "User 2 can only view the Perimeter 2".
I have seen some solutions in internet :
- Row Level Security in cloud (report services)
- Using username() in MS SQL Server
but it doesn't work for an access database in Power BI report server.
Can you help me please ?
Thanks in advance
See this similar thread:
Thanks for your reply !
They use Microsoft SQL Server as a database which allows to use SQL Query whereas I am using Microsoft Access database 😕
Moreover, they create some roles in order to segregate data according to the user but we can't view the role in Power BI Report Server 😕
Native Power Bi PLS doesn't work on PBIRS, it is a feature for Q4.
The only option is to push via ETL TO A SQL Server, make a direct query connection and use the native SQL RLS or use a SSAS cube.
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 |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |