Forum Discussion

Tosho's avatar
Tosho
Frequent Visitor
7 years ago

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?

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    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?