Scheduled refresh error

[sedden]

Hi Team,

I am seeing the bellow error when the schedule refresh runs. If I download the pbix file and enter the creds locally, it does refresh and I can then republish. Why does a manual refresh work and not a scheduled refresh? We have a numer of data sources, so how do I tie this error back to which datasource is causing this failure. I've hashed out the server name.

• Processing errorThe operation has timed out
• Cluster *********.analysis.windows.net
• Activity ID6b31fb90-b482-4f16-9acf-8e36459a706b
• Request IDedcbcaf0-3f66-4392-a5c3-74a6f019a389
• Time2022-03-15 14:03:57Z

[sedden]

No, no gateway configured. It does refresh sometimes as seen from the refresh history.

Details Type Start End Status Message

Show	Scheduled	3/15/2022, 1:03:09 PM	3/15/2022, 2:03:29 PM	Failed	There was an error when processing the data in the dataset.
Show	On demand	3/15/2022, 11:37:43 AM	3/15/2022, 12:42:18 PM	Failed	There was an error when processing the data in the dataset.
Show	Scheduled	3/15/2022, 6:05:08 AM	3/15/2022, 7:03:57 AM	Failed	There was an error when processing the data in the dataset.
	On demand	3/14/2022, 8:49:48 PM	3/14/2022, 9:03:49 PM	Completed
Show	On demand	3/14/2022, 4:18:10 PM	3/14/2022, 5:07:44 PM	Failed	There was an error when processing the data in the dataset.
Show	Scheduled	3/11/2022, 8:06:06 AM	3/11/2022, 8:40:38 AM	Failed	There was an error when processing the data in the dataset.
Show	Scheduled	3/10/2022, 4:05:07 PM	3/10/2022, 5:12:43 PM	Failed	There was an error when processing the data in the dataset.
Show	Scheduled	3/10/2022, 12:24:06 PM	3/10/2022, 3:16:43 PM	Failed	There was an error when processing the data in the dataset.
	Scheduled	3/10/2022, 8:06:10 AM	3/10/2022, 9:27:57 AM	Completed
Show	Scheduled	3/9/2022, 4:06:07 PM	3/9/2022, 5:27:10 PM	Failed	There was an error when processing the data in the dataset.
	On demand	3/9/2022, 2:08:10 PM	3/9/2022, 2:55:42 PM	Completed
	On demand	3/7/2022, 3:33:22 PM	3/7/2022, 4:00:33 PM	Completed
	On demand	3/6/2022, 10:05:23 PM	3/6/2022, 10:35:57 PM	Completed

[Tutu_in_YYC]

And no information in the log?

[sedden]

My View is a bit different, I dont see a download log button and if I click in show it give a timeout message with no indication on the data source responsible.

[Tutu_in_YYC]

Do you want to try some of my "caveman" troubleshooting methods?

1. Try refreshing individual tables on Power BI Desktop (not PQ) first to see if all the query runs w/o issue. Right click on table and refresh data.

2. if that works, publish the report to a different workspace and set schedule refresh.

If both 1 and 2 works, the original report in workspace may be corrupted (or some other thing). I dont encounter this often but it has happened before.

Are you using dataflows? direct-query or anything that is not a direct import?

What are your data sources ( SQL, sharepoint) ?

[Tutu_in_YYC]

Hi Sedden,
Are you using a gateway? If yes, you can check the connection for every datasource that you use in the model.