Error while scheduling refresh

[Ibad_Khan]

Hello PBI Community, hope you all are doing good.

I'm getting an error "There was an error when processing the data in the dataset." while scheduling refresh.

Can anyone help me out in solving this error? Detials are mentioned below.

 Looking forward for some positive responce.

@amitchandak 

Regards,

Ibad.

Data source error:	The operation is timed out.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI:	WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:	50a469ba-49ab-43b4-ac69-85aff531ae22
Request ID:	393a0655-4cb2-4aee-89c9-6c068321513b
Time:	2022-06-26 03:44:31Z

[v-cazheng-msft]

Hi @Ibad_Khan,

May I know whether this issue is transient or keeps happening? If you refresh it by on-demand refresh or schedule its refresh at some off-work time, will you get this issue as well.

If it fails all the time, then please download this report and refresh it in Power BI Desktop and let me know whether it will fail as well? Will you see any error in Power Query Editor(Transform data)? What’s your data source and connection mode to the data source? If it’s a SQL data source, please try prolong the command timeout in Connector dialog and observe dataset refresh to see whether the error will remove?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[Ibad_Khan]

@v-cazheng-msft  This issue occurs while scheduling refresh in working hours as well as in non working hours, and sometime scheduling refresh is completed successfully. 

In Power BI Desktop, refreshing is completed successfully.

There is no error is query editor and Data Souce is SQL Server.

Btw sometime the scheduling refresh is completed successully.

Regards,

Ibad.