Forum Discussion
Data refresh problem with calculated table from direct query
Hi Dimitris_Kats ,
In the power query, whether the "Include in report refresh" in the table is enabled
For the calculation table in Direct Query, it is equivalent to an import, you need to set the scheduled refresh in the dataset to keep it refreshed.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#calculated-tables
This is the related document, you can view this content:
https://community.powerbi.com/t5/Desktop/calculated-tables-do-not-update/m-p/598237
https://community.powerbi.com/t5/Desktop/Direct-Query-and-using-CalculateTable/td-p/2000160
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dimitris_Kats ,
In the power query, whether the "Include in report refresh" in the table is enabled
For the calculation table in Direct Query, it is equivalent to an import, you need to set the scheduled refresh in the dataset to keep it refreshed.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#calculated-tables
This is the related document, you can view this content:
https://community.powerbi.com/t5/Desktop/calculated-tables-do-not-update/m-p/598237
https://community.powerbi.com/t5/Desktop/Direct-Query-and-using-CalculateTable/td-p/2000160
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.