Forum Discussion
Report data not auto refreshing analysis services connection
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...
Hi derrickb,
Can you share some detailed information about your issue? It is hard to reproduce your issue form your description.
For e.g:
SSAS RLS setting, security setting, power bi connect mode, power bi role setting, workspace permission/security setting, screenshots...
Regards,
Xiaoxin Sheng
Hi Anonymous,
- The model utilizes RLS described in this article.
- Live connection to SSAS model.
- The report was published to a group workspace.
- Users with the refresh issue have proper access levels because the data loads fine if they manually refresh. A manual refresh is not required by all users.
- User with issue has member access but not allowed to edit.
- This is a very large report. It has 25 pages and around 200 different visuals.
- This report has caused other issues because whenever the model is updated, Power BI checks for this and updates the local cache for users that have the report. This causes a massive performance hit on our SSAS server because Power BI tries to update the cache for all users as quickly as possible (without a throttle) and brings our services to a crawl for an hour. My theory is the cache is not getting updated for some users; however, Power BI thinks the cache was updated; therefore, the report doesn't update when the user initially opens the report.