Forum Discussion
Solved
Calculated Columns not updating on scheduled refresh
I have created the following calculated columns: Domestic = if('Shipping Requests'[InternationalShipment]="TRUE",0,1) International = if('Shipping Requests'[InternationalShipment]="TRUE",1,0) G...
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.
GilbertQ
Super User
Super UserI would think that as long as the entire data is refreshed which includes your calculated columns it will then refresh the data.
If the calculated column is in a table that is not refreshed then it will not update the column data.
This is because the columns only get recalculated on the datamodel refresh.
If the calculated column is in a table that is not refreshed then it will not update the column data.
This is because the columns only get recalculated on the datamodel refresh.
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.
- GilbertQHi there
You are indeed correct that it should be refreshed.
Can you ensure that you are running the latest version of the On-Premise Data Gateway?