Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, So I have a report that is set for scheduled refresh and it refreshes no problem at all. However, even though certain table(s) have refreshed, they are missing data. In this example it is for a group of schools and I get their attendance data via an OData feed. The report is set up to show their attendance, but sometimes after a refresh, a schoolat random will be missing their data. If I force a refresh again all might appear, or another school (or 2) will be missing. Is there an obvious reason for this, anything I should be cehcking? I do have a few tables which refresh as part of the OData feed - no issue with the otehrs from what I can tell, as well as a couple of local files linked to the report and they refresh fine. Any help appreciated as I am hitting a brick wall!
Thanks
Mark
The issue you're experiencing with missing data after a scheduled refresh in Power BI can be caused by various factors. Here are some steps you can take to troubleshoot and resolve the problem:
Data Source Issues:
Refresh Order:
Dependency Chain:
Query Folding:
Data Load Settings:
Data Transformation Steps:
Error Handling:
Data Source Permissions:
Scheduled Refresh Settings:
Logging and Monitoring:
Data Source Versioning:
Incremental Refresh:
By carefully reviewing these aspects, you should be able to identify and resolve the issue of missing data during scheduled refreshes in Power BI. If the problem persists, you may want to engage with Power BI support or your data source provider for further assistance.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.