Forum Discussion

gp10's avatar
gp10
Advocate III
3 years ago
Solved

Redshift and Gateway issue

Hi community, I'm facing issues when trying to create a dataflow with Amazon Redshift data. The data that need to ne imported are over 1bn rows. I have tried to connect both with the Amazon Redshif...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago
    Then the pbix file is so big that it cant be published.

    You can bootstrap the incremental refresh partitions to keep the original size under 10 GB. Then use XMLA refresh to fill each partition separately. This will then allow you to load datasets that are half the size of your capacity, and supposedly even beyond.

Ashrafsleem2020's avatar
Ashrafsleem2020
Frequent Visitor
3 years ago

Same Issue

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. Table: beginning_balance.

 

 

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} 
Cluster URI: 
Activity ID: 
Request ID: 
Time:2023-03-30 10:37:34Z