Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
abhilashp
New Member

Row level security with analysis services in Power BI report server

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?

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.