Scheculed Refresh Fails, but Manual Refresh works

[PaulPalkowski]

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, the characters "25" aren't even in the query. Manual refresh and publishing works fine from desktop, but the Scheduled refreshes fail. What could possibly be the issue? 

[v-pgoloju]

Hi @PaulPalkowski,

Just following up to see if the response provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @PaulPalkowski ,

Just following up to see if the response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @PaulPalkowski,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Idrissshatila and @ibarrau  for prompt and helpful response.

Just following up to see if the response provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Idrissshatila]

Hello @PaulPalkowski ,

what I would do if if was in your place, is to download this the report from service (not checking the one on desktop) and then going to power query and cheking the tables making sure everyone of them load.

[ibarrau · Accepted solution]

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,