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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
TBStacey
Helper I
Helper I

Power Query Errors - Truncated chunk / Premature end of chunk coded message body

Hello all. I'm struggling with a query. I have numerous queries in a PBI desktop file, all of which update without errors, expect for 1. This 1 query is reliant on many of the others and I am getting errors that I'm unable to resolve. The data that is being accessed via the PBI file is through an online database that I've connected to which uses my credentials to login (in case that is helpful).

 

Below is an image of an updated query within power query of Power BI. You can see the query was successful per the highlighted green bars along beneath the header row. You can see the name of the query highlighted on the right under Properties and you can see I am on the last applied step of the query. The orange arrow is pointing to the broken query below this working query.

TBStacey_0-1730732546656.png

 

Below is an image of the broken query referenced above. I will paste the errors below the image. This image shows that the source (highlighted on the right under applied steps) of this query is the working query above. Since no steps have been applied to this 2nd query, the source step should display the exact same information as the image above. But it does not. It shows the below error. I’ve re-run the query multiple times and continue to get a variation of the error below, though each time a different number of rows are noted as loaded in the query.

TBStacey_1-1730732679246.png

 

DataSource.Error: ERROR [HY000] [Foundry] 2024-10-31T15:03:48.291Z 3.0.0 traceId: cee30e17f0ad52d3

Error whilst loading results. Loaded up to 114735 rows in PT1M25.581S - org.apache.hc.core5.http.TruncatedChunkException: Truncated chunk (expected size: 1048064; actual size: 1032185); org.apache.hc.core5.http.TruncatedChunkException: Truncated chunk (expected size: 1048064; actual size: 1032185); Truncated chunk (expected size: 1048064; actual size: 1032185)

 

DataSource.Error: ERROR [HY000] [Foundry] 2024-11-04T15:11:22.597Z 3.0.0 traceId: dfe2d1817f3bd5ea
Error whilst loading results. Loaded up to 112881 rows in PT1M45.653S - rg.apache.hc.core5.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected; org.apache.hc.core5.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected; Premature end of chunk coded message body: closing chunk expected

 

If anyone has ideas on what is going wrong, whether this is something I've done in error or if it points to something with the connection to the data itself, i.e., an issue with the database?, I would appreciate any insights. 

4 REPLIES 4
lbendlin
Super User
Super User

Please provide more details. What are your original data sources? Hive tables?

The data that is being accessed via the PBI file is through an online database that I've connected to which uses my credentials to login (in case that is helpful). The connection is through "Palantir Foundry".

TBStacey_0-1730754702425.png

I connect to numerous different datasets using RIDs. I'm not sure if this answers the questions, but I don't know what a hive table is.

 

Sounds more like an issue at the Palantir Foundry end.  Do you have a way to contact their support team?

I have looped in the support team as well, thank you!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors