cancel
Showing results for 
Search instead for 
Did you mean: 

error":{"code":"DM_GWPipeline_Client_ReceivedUncompressedDataExceedingLimit

DashBoard_NOME has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
{"error":{"code":"DM_GWPipeline_Client_ReceivedUncompressedDataExceedingLimit","pbi.error":{"code":"DM_GWPipeline_Client_ReceivedUncompressedDataExceedingLimit","parameters":{},"details":[],"exceptionCulprit":1}}}
Next refresh for Lora HeatMap is scheduled for January 25, 2022 9:30 UTC.

Status: Investigating

Hi , 

You can consider the following aspects:

1)Data limits 

Per Microsoft, the data limits imposed on Power BI Pro users are:

  • Maximum compressed data set the size of 1 GB.
  • Limit of 10 GB on the amount of uncompressed data that is processed during refreshes.
  • No data size restrictions in Power BI Premium.

For more details, please refer to this document.

vrobertqmsft_0-1643075201542.png

 

Data refresh timeout:

Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

 

2) ODBC  command timeout

You can modify the following parameters in query edit. 

For more details, please refer to this document.

Odbc.DataSource(connectionString as any, [ConnectionTimeout=#duration(0,2,0,0),CommandTimeout=#duration(0,2,0,0)])

 

In addition,  you can take a try of incremental refresh (it is also now available in Pro).

 https://powerbi.microsoft.com/en-us/blog/incremental-refresh-is-generally-available/

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

Hi , 

You can consider the following aspects:

1)Data limits 

Per Microsoft, the data limits imposed on Power BI Pro users are:

  • Maximum compressed data set the size of 1 GB.
  • Limit of 10 GB on the amount of uncompressed data that is processed during refreshes.
  • No data size restrictions in Power BI Premium.

For more details, please refer to this document.

vrobertqmsft_0-1643075201542.png

 

Data refresh timeout:

Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

 

2) ODBC  command timeout

You can modify the following parameters in query edit. 

For more details, please refer to this document.

Odbc.DataSource(connectionString as any, [ConnectionTimeout=#duration(0,2,0,0),CommandTimeout=#duration(0,2,0,0)])

 

In addition,  you can take a try of incremental refresh (it is also now available in Pro).

 https://powerbi.microsoft.com/en-us/blog/incremental-refresh-is-generally-available/