Calculated Columns not updating on scheduled refresh

[PaulWo]

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

[USGeb]

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.

[PB2024]

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

[PaulWo · Accepted solution]

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]

Hi there

By putting it into the Query Editor, it will always be refreshed every time that the entire dataset is refreshed.

[GilbertQ]

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

[PaulWo]

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.

[GilbertQ]

Hi 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?

[PaulWo]

I'm not using a gateway connection.  All my data sources are in the cloud.

[GilbertQ]

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

[PaulWo]

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.    

[GilbertQ]

It would appear then that the refresh is happening.

I am not sure why the calculated column is not updating.

Would it be possible to run manually on Power BI Desktop and see?

[PaulWo]

When I refresh on the desktop everything looks good.  When I publish to the BI service and review the report on the BI service everything looks good.  When I shedule auto refresh from the BI service everything, credentials, access ect looks to be set up correctly.  When the scheduled refresh runs the BI service reports the refresh was successfully completed.  When I look at the report after the 1st scheduled refresh, the calculated measures I described at the begining of this thread do not display correctly.

[pronkrcgj]

I have the same problem. Do you have now a solution for this problem?