Forum Discussion
Refresh All and Service refresh not returning new data — manual table refresh works fine
Hi chelly911,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to garvitgupta96, Lodha_Jaydeep, for those inputs on this thread.
The issue is not with the gateway or data load, but with semantic model processing failures. Your refresh is successfully pulling data (as seen from the row count), but the warnings like missing columns/tables, invalid DAX, and type mismatches indicate that parts of the model (calculated columns, measures, relationships) are breaking during a full refresh. When this happens, Power BI keeps the last valid model state, so visuals continue to show old data. Manual table refresh works because it only executes Power Query (M) and doesn’t validate the full model.
To fix this, resolve all model warnings/errors: correct DAX references, ensure columns/tables exist, and fix data type mismatches (e.g., in SWITCH). Also review relationships and remove any broken dependencies. As a check, temporarily disable calculated tables/columns and run Refresh All, if new data appears, the issue is confirmed in model logic. Once all errors are fixed, clear cache, refresh again, and republish to the Service. After the model processes without warnings, new data will appear correctly.
Thank you for using the Microsoft Fabric Community Forum.
Hi chelly911,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to garvitgupta96, Lodha_Jaydeep, for those inputs on this thread.
Has your issue been resolved? If the response provided by the community member garvitgupta96, Lodha_Jaydeep, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Nothing worked, thanks.
Hi chelly911,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to garvitgupta96, Lodha_Jaydeep, for those inputs on this thread.
The issue is not with the gateway or data load, but with semantic model processing failures. Your refresh is successfully pulling data (as seen from the row count), but the warnings like missing columns/tables, invalid DAX, and type mismatches indicate that parts of the model (calculated columns, measures, relationships) are breaking during a full refresh. When this happens, Power BI keeps the last valid model state, so visuals continue to show old data. Manual table refresh works because it only executes Power Query (M) and doesn’t validate the full model.
To fix this, resolve all model warnings/errors: correct DAX references, ensure columns/tables exist, and fix data type mismatches (e.g., in SWITCH). Also review relationships and remove any broken dependencies. As a check, temporarily disable calculated tables/columns and run Refresh All, if new data appears, the issue is confirmed in model logic. Once all errors are fixed, clear cache, refresh again, and republish to the Service. After the model processes without warnings, new data will appear correctly.
Thank you for using the Microsoft Fabric Community Forum.Hi chelly911,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.