Forum Discussion
Helper IProblem with updating the Power BI Report Server dashboard
It turned out to be much simpler. Friends, it turns out that updating data in SQL Server takes longer, and the dashboard simply connects when the data in the final table is not yet ready. Therefore, it is empty. The issue has been resolved.
Community Support
Helper IWhat is your server version? and what is the account's server role? Is this a .pbix file or a Report Builder file?
- v-tejrama
Hi ReyCarter_777 ,
This issue in Power BI Report Server is usually related to version compatibility, file type, or permissions, so please ensure the report is created using the matching Power BI Desktop for Report Server version as a mismatch can block updates or publishing, also confirm whether the file is a .pbix or .rdl since they are handled differently, and verify that your account has Publisher or Content Manager role at the folder level which is required to update reports.Refer these Microsoft docs:
https://learn.microsoft.com/en-us/power-bi/report-server/changelog
https://learn.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server
Thank you. - ReyCarter_777
I didn't understand your answer. Initially, said it was about caching. Showed a screenshot (I don't have such items as subscriptions, caching, or snapshot history in my power bi .pbix Report Server. Now, the problem may be in the version, file types, and permissions. Although our versions are all the same, the files are.pbix, maximum permissions. I like the first reason I mentioned about the cache, but I don't see how to fix it.
- v-tejrama
Hi ReyCarter_777 ,
Thank you for the clarification it helps clear up the confusion. In Power BI Report Server, features such as subscriptions, caching, and snapshot history are available for paginated reports (RDL), but these options may not be visible for .pbix reports. For .pbix reports, the recommended method is to refresh the data in Power BI Desktop and then republish the report to Report Server to update it. Please ensure the report has been refreshed, redeployed, and that you are viewing the latest published version.
Thank you. - ReyCarter_777
Colleagues from Microsoft, I ask for your help in solving this incident.
Currently, there is a pbix dashboard that opens empty when updated, and this happens every morning (even though the scheduled update shows a successful status).
What is the reason for this, and how can it be fixed?
We have tried resaving, updating the model, and playing with permissions and updates, but none of these solutions have worked.
It is surprising that this issue only affects one dashboard, as we have not encountered similar problems with other dashboards.