Forum Discussion
Calculated Columns not updating on scheduled refresh
The calculated columns I described at the start of this thread were created in PowerBI Desktop. I tried moving the creation of these calculated columns to the Power Query Editor. That change eliminated the problem. Not sure why but it worked.
The datatable containing the calculated columns is refreshed. It is my understanding the if you schedule a data refresh all Import mode dataset types are retrieved and recalculated. My comment regarding "keep the underlying data unchanged" was to say the data used to sum Domestic, International and Grant | MTA columns did not change.
My auto refresh history appears to be successful -
I appreciate your response. Issue still exists.
Super UserYou are indeed correct that it should be refreshed.
Can you ensure that you are running the latest version of the On-Premise Data Gateway?
I'm not using a gateway connection. All my data sources are in the cloud.
- GilbertQHi there
That could possibly explain why it is not refreshing, because it is not using the Power Query Refresh which in turn then updates the Power BI dataset.My scheduled refresh should be performing the Power Query Refresh. Other areas of the report update so I do think a refresh query is occuring. Perhaps I don't understand your last comment.