cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Calculated table does not refresh after published to Workspace

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.

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Calculated table does not refresh after published to Workspace

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?

 

mixed.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Regular Visitor

Re: Calculated table does not refresh after published to Workspace

Hi @v-frfei-msft ,

 

No I did not perform any scheduled dataset refresh, because the underlying table is a direct query.

 

image.png

 

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...

Highlighted
Community Support
Community Support

Re: Calculated table does not refresh after published to Workspace

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.

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Highlighted
Regular Visitor

Re: Calculated table does not refresh after published to Workspace

Hi !  I too am experiencing this issue and would like to know how to overcome.  Crafting reports with direct query is meant to keep the report always current such that a user doesn't have to worry about refreshes or schedule cycles (which, due to limits on the number of cycles per day, does not enable one to keep a report always current).  One would think that hitting refresh should trigger calculated tables to refresh to align to the underlying data, and if the underlying data is direct-query driven, the calculated table should always be in sync.  What's the way forward ?  If I have to schedule a refresh simply to update calculated tables based on direct query data, that's a severe limitation to the advantage of direct queries (ie "only use direct queries if you have no calculate tables").

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors