Forum Discussion
Calculated Columns not updating on scheduled refresh
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.
Super UserThat 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.
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.
- GilbertQIt 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?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.
I have the same problem. Do you have now a solution for this problem?
