Forum Discussion

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

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

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

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