Scheduled refresh failure.

[k3rz0rg]

Hi all,

is anyone exeperiencing the scheduled refresh failure for internal service error? 

Funny thing is not all the reports but randoms. Tried to force refresh but same issue. I am experiencing this issue since this morning.

Any suggestion to get out of this situation would be a great help.

Thanks,

K3.

[GilbertQ]

Hi there

I would suggest opening the PBIX file and refresh the file to see the error.

[v-yuta-msft]

Hi k3rz0rg,

Please check if any column is deleted or renamed on data source side. Please open Query Editor check which step has issue. After the report can be refresh successfully in Power BI desktop, then republish the report to Power BI service.

Regards,

Jimmy Tao

[k3rz0rg]

Hi @v-yuta-msft,

I checked everything, I have multiple reports with exact same thing, only a where condition different from each other in query and few gets refreshed and few don't. I checked the query editor and no issue. I can refresh the data from desktop and republish it and in fact, that's what I've been doing it but this reports require auto refresh. I am experiencing that issue since yesterday and every time it's failing and this morning, schedule refresh got disabled. 

I also wanted to add that the same report is published in different workspaces and there it's working fine both scheduled and on-demand refresh.

@GilbertQ, thanks for the response and yes that's what I've been doing for now.

Thanks,

K3.