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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rturnheim
Frequent Visitor

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_CompressedDataSizeForPacketExceededError","parameters":{},"details":[],"exceptionCulprit":1}}}Cluster URI:WABI-WEST-EUROPE-redirect.analysis.windows.netActivity ID:e11213d3-dda1-44c5-b555-88b48663828bRequest ID:333b39d1-06af-4147-92f7-47e3193ab95bTime:2023-08-22 21:21:56Z

 

I use 2 data sources: Sharepointfolder and Redshift (with select statement to limit data pulled). Sharpoint folder contains 2100 files each 10MB uncompressed text files; PBIX file has a size of 76 MB.

All this seems not a challenge. It stopped working when I changed to select statements for redshift (through advanced) and import to limit info loaded. No issues with desktop refresh.

Any advice would be helpfull.

Thanks

Rene

1 ACCEPTED SOLUTION
rturnheim
Frequent Visitor

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.

View solution in original post

6 REPLIES 6
rturnheim
Frequent Visitor

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.

rturnheim
Frequent Visitor

Thanks I will check on this tomorrow. Appreciate the fast response.

Rene

GilbertQ
Super User
Super User

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.

GilbertQ_0-1692742962718.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Still waiting from support for the changes. Will keep you in the loop.

Thanks

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors