Forum Discussion

PaulPalkowski's avatar
PaulPalkowski
Icon for Helper II rankHelper II
1 year ago
Solved

Scheculed Refresh Fails, but Manual Refresh works

My scheduled refreshes are failing telling me that a column "Column 25" could not be found. After looking at the query in the advance editor, there isn't any reference to anything called Column 25, t...
Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. Make sure there is not warning message when refresing a Power Bi Desktop. You can open the query editor. Go table by table selecting all columns and filter by keep errors. Some errors can be a warn for desktop but an error for service.

    If all tables are loading correctly at desktop without an error, then publish back overwritting the report.

    If it still has an error and you think it might be broken. Try publishing to a different workspace and refresh it.

    I hope that helps,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
1 year ago

Hi. Make sure there is not warning message when refresing a Power Bi Desktop. You can open the query editor. Go table by table selecting all columns and filter by keep errors. Some errors can be a warn for desktop but an error for service.

If all tables are loading correctly at desktop without an error, then publish back overwritting the report.

If it still has an error and you think it might be broken. Try publishing to a different workspace and refresh it.

I hope that helps,