Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Data Refresh Error

Submitted by Anonymous on ‎07-19-2018 09:19 AM

The scheduled data refresh for a certain report published in the PowerBI Service keeps failing with this error:  "An error occurred while processing the data in the dataset.  The CancellationTokenSource has been disposed.. The exception was raised by the IDataReader interface. Table: cmv_Sales."  There are no other details, and I can't seem to find a cause/solution online.  Has anybody seen that type of error before?  Thank you very much!

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎07-20-2018 08:39 PM

Hi @Anonymous,

 

There should be RequestID, Time and ClusterURI information display when you check details in Refresh History. Please share these information for us. 

 

You can download the report from Power BI service and open it in Power BI desktop, click Refresh button to see if the refresh can be successful. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎07-20-2018 08:40 PM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎07-23-2018 02:03 PM

Thanks for your quick reply Vicky.  Here is the technical information from the morning of 7/19/18:

Activity Id: ed918def-c1fc-4ecd-9ab0-9a84c93adcdb

Request Id: 75f6138f-adb8-4982-bfaa-bc0c9a7ade41

Cluster Name: WABI-WEST-US-redirect.analysis.windows.net

Refresh Start Time: 07/19/2018 13:02:14Z

Refresh End Time: 07/19/2018 13:33:01Z

 

Now I see the following:

Last refresh failed: Sun Jul 22 2018 07:04:28 GMT-0700 (Pacific Daylight Time)
The amount of uncompressed data on the gateway client has exceeded the limit of 10 GB for a single table. Please consider reducing the use of highly repetitive strings values through normalized keys, removing unused columns, or upgrading to Power BI Premium.Hide details

Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:4174efd5-fdab-4b06-8afa-7fff851802e8
Request ID:dae711bf-3fe2-4548-a87c-e298a12f4b53
Time:2018-07-22 14:04:28Z

 

Thank you for your help.

Idea Statuses