Calculated tables or calculated columns causing refresh errors

Hello Anonymous,

Calculated tables/columns that reference remote tables can cause refresh issues. Test if removing these calculated tables resolves the issue. If the calculated tables are essential, consider creating them in a way that doesn't rely on direct queries to remote data sources.

If possible, import the data from the other Power BI datasets into your main report, rather than using direct queries. Its also worthwile making sure the flow is set up to refresh the data in SharePoint correctly and that Power BI is scheduled to refresh after these updates. When dealing with complex transformations and multiple data sources, Power BI Dataflows might be a more efficient way to prepare your data before it gets to your report.

Should you require any further assistance, please do not hesitate to reach out to me.