When some (not all) users access a report connected to an on-prem analysis services model, the visualizations are not refreshing. Even clicking on another page does not refresh the data. The user has to click the Refresh button in Power BI to update the data.
This is an inconsistent bug that occurs with some users, but not all. Although I've only done limited testing, members have the issue, but owners do not. I noticed this because owners have the ability to edit the report... members do not.
Here are the detailed steps:
User accesses report in a group workspace on PowerBI online/web version.
When user opens report, it is reporting the 2016 data.
User has to refresh each page to get current 2017 data.
When user closes PowerBI web and re-opens, the summary page is back to the 2016 data.
This has occurred over and over again.
Can you share some detailed information about your issue? It is hard to reproduce your issue form your description.
SSAS RLS setting, security setting, power bi connect mode, power bi role setting, workspace permission/security setting, screenshots...
I'd like to suggest you do some additional test to find out where the issue is.
If this issue only appear on specific users, it may caused by RLS.
If the issue random appeared, it may related to power bi.
In addition, you can also take a look at below links:
Power Bi refresh
Power BI Security
I perfromed additional testing and it's random, pointing to a Power BI issue. Some users with the same security settings have the issue, some do not. The issue occurs on the service and in the Power BI app.
It's not a refresh scheduling issue because the report is connected to an on-prem analysis services tabular model and is automatically refreshed. It's not an RLS issue due to randomness described above.
Sorry for slow response, I try to reproduce your issue but failed. I'd like to suggest you submit a support ticket for this issue:
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.