cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tosho Frequent Visitor
Frequent Visitor

Power BI doesn't take changes in SSAS role

Hi everyone

I'm currently working for a retail company, they have Power BI Premium P1. The most of models are developed using Visual Studio 2015 and hosted in SQL Server 2016 Enterprise Edition. The last days the client (the company) detected an issue where an user is changed of role (both with diferent permissions), then changes are not taked by the report in Power BI Service (app.powerbi.com) it continue showing the data for the first role where the user was assigned. I maked some test and in fact the chages in SSAS roles isnt taked by the Power BI Service, but if the tabular model is connected from Excel then all work fine in Excel only.

 

Additional info

The gateway is updated

The dataset refreshing settings are programated every 15 min (for cache)

I deleted the browser cache

SSAD database is tabular and the compatibility level is 1200

 

but nothing work. This is happening for some (dont all) models in the same SSAS instance.

 

Do you thing some reason by that?

1 REPLY 1
Super User
Super User

Re: Power BI doesn't take changes in SSAS role

Hi there

What I would suggest doing is when the user is coming from the Power BI Service to ensure that the user mapping is in place.

And to then see if via SQL Query profiler.

One last thing to note is that for SSAS Tabular RLS the security being applied is the least restrictive.
What that means is that if a user belongs to multiple roles the user will see all data for both of the roles.
This might be what is happening?

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

"Proud to be a Datanaut!"


Power BI Blog

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 138 members 1,768 guests
Please welcome our newest community members: