Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Background:
I have few PowerBI reports with data source as Azure analysis services (tabular) in direct query mode. The analysis services database is authenticated using azure active directory. I am able to publish the reports to the on-premise power bi report server and view it by storing the credentials in the datasource.
Challenge:
I want to provide access to the users in the org to view the reports from the report server. Also, row level security needs to be implemented to filter the dimensions based on the user viewing the reports. However, the credential to access the data source works only with basic authentication and not windows authentication. Due to this I am unable to pass the details of logged in user to the analysis services for row level security.
Is there any way to implement row level security in this context?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |