cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ascendbi Regular Visitor
Regular Visitor

Re: The received uncompressed data on the gateway client has exceeded limit.

Hi @iJuancho - nice work - what were the data types before you changed them? 

Highlighted
iJuancho Frequent Visitor
Frequent Visitor

Re: The received uncompressed data on the gateway client has exceeded limit.

In my case, The data type changes I made were:

 

- 9 columns of INT (4 bytes) to TINYINT (1 byte) => 45 millions * 9 columns * 4 bytes = 1.5Gb vs 386MB

- 5 columns of INT to SMALLINT (2 byte) => 45 millions * 5 columns * 4 bytes = 858Mb vs 429MB

- 4 columns of DECIMAL(14, 6) (13 bytes) to SMALLMONEY (4 bytes) = 45 millions * 4 columns * 13 bytes = 2.2Gb vs 686Mb

- 1 column of Varchar(50) to Varchar(30) = 2.1Gb vs 1.2Gb

 

If we add the changes these give us:

Before = 6.6GB

After = 2.7Gb

 

Finally, my fact table has a UNION between Sql Server and Oracle. When defining my Sql Server table as primary, Power BI takes the metadata of the primary table and forces data coming from Oracle to have that same data type.

 

 

ascendbi Regular Visitor
Regular Visitor

Re: The received uncompressed data on the gateway client has exceeded limit.

Hi @iJuancho

 

It appears I will need to investigate the same approach you did in reducing the data sizes. See our response from MS here: 

http://community.powerbi.com/oxcrx34285/board/message?board.id=power-bi-web-app&message.id=27670#M27...

 

So the data type changes you made below... did you make them at the database table level or did you change their type in a SQL view or Stored Procedure? 

 

Thank you 

ghadeerelzein Frequent Visitor
Frequent Visitor

Re: The received uncompressed data on the gateway client has exceeded limit.

Can you please how can you manually work around this problem since it is still happening till now. Regards

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 254 members 3,007 guests
Please welcome our newest community members: