cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
littlemojopuppy
Super User I
Super User I

Power BI Premium RLS

I have a tabular model on Azure Analysis Services with RLS defined in the database (roles and permissions).

 

Can I deploy that exact same model into Power BI Premium with RLS still defined in the model?

1 ACCEPTED SOLUTION

Hi @GilbertQ.  I don't mean publish a dataset as part of a pbix file.  What I'd like to do is publish an analysis services database directly into Power BI Premium (instead of onto an AAS or SSAS server).  It seems that I can publish the data model without roles into Premium, but not with.

View solution in original post

8 REPLIES 8
v-kkf-msft
Community Support
Community Support

Hi @littlemojopuppy ,

 

Does you try to connect to Azure Analysis Services datasource using live connection mode?

 

See if these documents are helpful:

 

https://community.powerbi.com/t5/Power-Query/Azure-Analysis-Services-Azure-AD-and-RLS/td-p/134631 

Connect to Analysis Services tabular data in Power BI Desktop 

Implement row-level security in an on-premises Analysis Services tabular model 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

Hi @v-kkf-msft the problem is RLS defined within the data model on Power BI Premium.  It's not supported...has to be implemented in the report.

GilbertQ
Super User II
Super User II

Hi @littlemojopuppy 

 

I would suggest publishing via the PBIX into your premium workspace. This will allow to add the required roles. 


The way the roles is stored in PBI Premium is different to AAS or SSAS and this is the only way to get it working!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ.  Unfortunately I can't.  But thanks for helping.

GilbertQ
Super User II
Super User II

Hi @littlemojopuppy 

 

I am not 100% sure exactly what you are doing, but the roles do work and I have deployed roles to Power BI Pro, Premium and Premium Per user successfully.

 

One thing for sure is DO NOT add them via Tabular Editor as this is not currently supported and can break your PBIX file. You have to do it via the manage roles in PBI Desktop.

 

If you have added the roles via Tabular Editor you are best off creating a new PBIX file and brining all your data, relationships etc back in and then configuring the roles in the PBIX.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ.  I don't mean publish a dataset as part of a pbix file.  What I'd like to do is publish an analysis services database directly into Power BI Premium (instead of onto an AAS or SSAS server).  It seems that I can publish the data model without roles into Premium, but not with.

View solution in original post

GilbertQ
Super User II
Super User II

Hi @littlemojopuppy 

 

Yes this can be done, and it will be done via the Manage Roles in Power BI Desktop or once deployed via SSMS





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ.  Thanks for replying.  🙂

 

I deployed a test into Power BI Premium yesterday and was playing around with it.  No issues if I don't deploy roles...failure if I did.  Further, if I added roles to that dataset on Premium using Tabular Editor, failure.  So I was expecting the answer to be "no I can't" because RLS isn't supported on Premium.

 

What's strange is if I open desktop and connect to that test dataset on Premium, the ability to manage roles is disabled.  🤔

 

I read in a blog yesterday...either SQLBI or Reza Rad I forget which...that Power BI Premium is supposed to be a "superset" of featues from Analysis Services.  Meaning it was intended to do everything SSAS/AAS can do plus more.  It's Microsoft's area of focus.  But not supporting RLS within the dataset itself seems like a huge, epic fail.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps