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?
