Row Level Security not working in Analysis Services with Power BI Report Server

Question

Hi,&nbsp;I set Row Level Security but users can still see all the records even if they are not allowed to.&nbsp;At the same time it works fine when using DAX query from inside SQL Server Management Studio, users can only see rows they have access to.&nbsp;I am using SQL Server 2017&nbsp;Power BI Report Server Version: 2.73.5586.1501 64-bit (September 2019)&nbsp;Any idea why the row filter does not work in Power BI Report Server?

greg_deckler · Answer

So you are using the directions here?
&nbsp;
https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server
&nbsp;

anonymous · Answer

Thanks Greg for replying, yes, I am doing the same steps except I am doing it in directly in SQL Server Analysis Services.

It also works fine if I query the model using DAX. The problem happens in PBI RS only.

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
It was a bug known as awareness before, but was fixed by the EOD 3/4/2020 . could you please try again?
If still not work, please kindly raise it to the support team for better research.https://powerbi.microsoft.com/en-us/support/&nbsp;

anonymous · Answer

Thank you&nbsp;v-diye-msft&nbsp;, How can I download the fix please?&nbsp;Is it a fix for Power BI Desktop RS or SQL Server Report Server?&nbsp;&nbsp;I am using Analysis Services onprem version 14.0.249.28

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
It's a fix for Power BI RS.
You can download it from the official website.&nbsp;

Forum Discussion

Row Level Security not working in Analysis Services with Power BI Report Server

6 Replies

Related content

Cohort analysis

Azure Analysis Service Migration Scenarios

Error Querying from Analysis Services Source

Retention analysis

Role Level Security