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.
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.
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!