Forum Discussion

PaulWo's avatar
PaulWo
Frequent Visitor
6 years ago
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...
Need Help
  • PaulWo's avatar
    PaulWo
    6 years ago

    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's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
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's avatar
PaulWo
Frequent Visitor
6 years ago

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's avatar
    pronkrcgj
    New Member
    6 years ago

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