Forum Discussion
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)
GrantOrMTA = if('Shipping Requests'[AgreementOrGrantFlag]="TRUE",1,0)
In my report I use Multi-row card to show the sum of each column. I have also tried a visual card for each with the same results.
When 1st publised to My Workspace, the data is correct. It remains correct each time I re-publish from the desk
Then I schedule a refresh and for the momemt keep the underlying data unchanged. Following the refresh the multi-card changes to the following:
I have reviewed the posted troubleshooting refresh scenarios, https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios and do not believe the suggestions provided include my problem.
Any help much appreciated,
Thanks, PaulWo
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.
13 Replies
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
Hi there
By putting it into the Query Editor, it will always be refreshed every time that the entire dataset is refreshed.
- GilbertQI 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.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?
i'm having the same problem and my calculated columns use lookups that can't be used in power query unfortunately, seems silly that calculated columns won't update
Hi there,
I have exactly the same issue, the calculated field works fine in PWBI DSK but not in the PWBI service unless i edit the formula of the calculated filed and due the calculation is made using Today Date the day after the calculated value is again not corect. The calculated value is also not refreshed in the sparepoint list where i have the formula but that field looks correct calculated within Power Bi Desktop Report (sourced by the sharepoint list) . That i do not understand.
