https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-with-analysis-services-in-Power-BI-report/m-p/613569#M9416 <P><STRONG>Background:</STRONG><BR />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.</P><P><STRONG>Challenge:</STRONG><BR />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.</P><P>&nbsp;</P><P>Is there any way to implement row level security in this context?</P> Thu, 31 Jan 2019 07:13:44 GMT abhilashp 2019-01-31T07:13:44Z https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-with-analysis-services-in-Power-BI-report/m-p/613569#M9416 <P><STRONG>Background:</STRONG><BR />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.</P><P><STRONG>Challenge:</STRONG><BR />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.</P><P>&nbsp;</P><P>Is there any way to implement row level security in this context?</P> Thu, 31 Jan 2019 07:13:44 GMT https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-with-analysis-services-in-Power-BI-report/m-p/613569#M9416 abhilashp 2019-01-31T07:13:44Z