cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jondon29 Frequent Visitor
Frequent Visitor

Packet Size preventing refresh of remote server

Thanks in advance for any support you can provide.

 

Working with Microsoft support, I was able to determine that the size of a query/column is preventing my table from being refreshed via an onsite gateway.  The body of the message from the product team is below:

 

we see one of the packet with the size over 8MB has been blocking the process here, which in turn means one of the column has the arbitrary value over the threshold which is causing the issue.

 

10768a89-4e2a-4f61-bed2-a9119c436b87    C146AA94 [DM.Relay] Not compressing or shrinking 9367921 bytes compressed with Level6

 

cb01fec9-1267-41e3-a1b0-711bf8b82e64    48AAEF35 [DM.GatewayCore] Executing query (timeout=7124) "<pi>SELECT * FROM [Query1]</pi>", requestId=null

 

could you please check The aforementioned exception present in which query or the column is producing huge sized packet, we would suggest you to try modifying the query accordingly or delete the column which is the cause here and try the refresh again.

 

My question is how can I identify which querry is causing the 8MB process?  Is there a function or utlity within BI that can identify the memory need for the request?  My file updates on the desktop version of BI and only has the error when refreshing via the server.

1 REPLY 1
Community Support Team
Community Support Team

Re: Packet Size preventing refresh of remote server

@Jondon29 ,

 

I'm afraid currently power bi doesn't have such kind of utility. I would suggest you to submit your idea here.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.