Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Data Refresh Error

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
Comments
v-qiuyu-msft
Community Support

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
Status changed to: Needs Info
 
Anonymous
Not applicable

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.