cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dheeraj10
Microsoft
Microsoft

Unable to test RLS in power bi service with Azure Analysis service

Hi All,

 

I had recently migrated my on-prem analysis service to azure analysis service.

I used to test RLS in my reports connected to on-prem analysis service by following steps:

1. Open "Manage Gateways" in power bi service.

2. Under Gateway Cluster, click on the data source configured for the report to access the cube.

3. Then click on Users tab, and click on "Map user name"

dheeraj10_0-1595004755883.png

dheeraj10_1-1595004829451.png

I used get the below where is can give my email in "Replace" and impersonation email in "With"

dheeraj10_2-1595004893712.png

After this process, when i used to open the report i was viewing as impersonated email.

Since I moved to Azure analysis service, On Prem gateway will be available in azure portal directly.

And I dont need to configure the data source. I can publish the reports directly to my workspace and give access to users to view the reports.

To test RLS in power bi service connected to Azure analysis service, is there any way like above mentioned ?

Please help me out.

 

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @dheeraj10 ,

 

Previously, you were only able to implement RLS within on-premises Analysis Services models outside of Power BI. For Analysis Services or Azure Analysis Services live connections, you configure Row-level security in the model, not in Power BI Desktop. The security option will not show up for live connection datasets.

 

For reference:

 

Row-level security (RLS) with Power BI

 

Row Level Security with SSAS Tabular Live Connection in Power BI

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
v-xicai
Community Support
Community Support

Hi @dheeraj10 ,

 

Previously, you were only able to implement RLS within on-premises Analysis Services models outside of Power BI. For Analysis Services or Azure Analysis Services live connections, you configure Row-level security in the model, not in Power BI Desktop. The security option will not show up for live connection datasets.

 

For reference:

 

Row-level security (RLS) with Power BI

 

Row Level Security with SSAS Tabular Live Connection in Power BI

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!