Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.