Forum Discussion

rturnheim's avatar
rturnheim
Frequent Visitor
3 years ago
Solved

Refresh error with redshift through gateway

Hi I would need help please: I get error message: Data source error:{"error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","pbi.error":{"code":"DM_GWPipeline_Gateway_Com...
Need Help
  • rturnheim's avatar
    rturnheim
    2 years ago

    It seeems the issue is not related to redshift. The Sharpoint files read is creating the [problem. I changed it to Sharepoint content read and this resolved the issue. Now I need to add incremental refresh and then I should be all set.

GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi rturnheim 

 

I would make sure that you have got the latest version of the redshift ODBC Driver installed.

Also ensure that you have got the latest version of the Power BI Gateway installed?

 

Then I would go into the advanced settings for Redshift and ensure that you have not put the settings to high?

In my client settings I have set the option to Single Row Mode which is still fast.

 

rturnheim's avatar
rturnheim
Frequent Visitor
2 years ago

Hi

I extended my testing and created seperate PBIX files for the redshift data versus Sharepoint. It seems now the error comes from Sharepoint and the amount of files there. The error stays with the Sahrepoint data source and not redshift. I will now reduce the files in each folder and go from there thanks for your help. Rene

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Thanks for letting us know you are getting closer to the resolution!