Forum Discussion
Calculated table does not refresh after published to Workspace
Hi,
I am using calculated table pulling data from direct query table. When I publish the report to Workspace, it seems that the calculated table does NOT refresh. However, according to the below document, it states that the calculated table should be refreshed when ever the underlying data is refreshed.
https://docs.microsoft.com/en-us/power-bi/desktop-calculated-tables
Did I miss anything? Please help... Thanks.
Hi ImNewUser ,
Based on my test, for calculated table in direct query, that is kind of import. So in your scenario, you should set schedule refresh of your dataset to make it keeping refreshed. As the picture below, we can only set schedule refresh not cache refresh.
4 Replies
Hi ImNewUser ,
Based on my test , I cannot reproduce your issue here. Did you set schedule refresh of your dataset? Could you please refresh your dataste to check again?
Hi v-frfei-msft ,
No I did not perform any scheduled dataset refresh, because the underlying table is a direct query.
From the above, "VillageTable" is the calculated table and "V_TAR_OutageVillageBase" is the query that the calculated table pull data from.
However, it seems that even if I explicitly click "Refresh", the table of directquery refreshed, but the calculated table does NOT refresh.
Please help...
Hi ImNewUser ,
Based on my test, for calculated table in direct query, that is kind of import. So in your scenario, you should set schedule refresh of your dataset to make it keeping refreshed. As the picture below, we can only set schedule refresh not cache refresh.
