Forum Discussion

ElliotP's avatar
ElliotP
Post Prodigy
9 years ago

Data Refresh Failed, Published to Web

Evening,

 

I've published my reports to the web and setup the scheduled refresh. It's failed now a few times and listed these two reasons;

 

Data source type:	
Processing error:	Timeout expired. The timeout period elapsed prior to completion of the operation.
Cluster URI:	WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID:	ef7e4815-404f-410a-aed1-0c90ea5f4326
Request ID:	ed322d18-99e5-4822-8b7c-209f58bedd64
Time:	2017-08-12 18:08:46Z
The refresh operation failed because it took more than 120 minutes to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets.

Cluster URI:	WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID:	1f5d244c-2dd2-4ef9-a5b0-ed6b3b90632e
Request ID:	6539095c-b648-4e03-8d4c-23d05e783bda
Time:	2017-08-12 22:22:56Z

The reports contain no errors in powerbi desktop and refresh on my desktop seamlessly.

 

From the error messages and looking around the forums, reducing the size of my dataset would help. The .pbix has a lot of calculated columns (a lot) from development amongst other things which might be slowing down the processing/speed ability. I was curious if anybody knew a solution, if it was possible to upgrade past this issue in terms of processing capability/time or if I simply need to clean up my .pbix and reduce my dataset to a certain amount (would love a refrence).

 

I have Powerbi pro, but I'm having an issue with the ticketing system that I'm currently working on resolving in another thread.


Warm Regards

1 Reply