Forum Discussion
DataflowsError
Thanks for the response all of this is already taken care of still the issue persists , for incremental load to happen it has to do full load first time right ? colums are reduced to what is required , it works absoultely fine in QlikSense
Hi ArvindJha,
Thanks for reaching out to the Microsoft fabric community forum.
You're right about Power BI requiring a full load initially when Incremental Refresh is enabled, and it sounds like you've already optimized the dataset thoughtfully.
One thing to consider is how the query steps are structured within the dataflow. If a particular transformation (like a merge, append, or expand) results in a very large in-memory object even briefly it can cause a single packet to exceed the allowed uncompressed size, leading to this error. Unlike QlikSense, Power BI doesn’t stream all data step-by-step during transformation and might materialize intermediate results in memory depending on how the query is built.
If possible, try reviewing the query steps to see if a specific operation may be generating a large intermediate dataset. Breaking that transformation into smaller steps, perhaps by materializing earlier steps into a staging Dataflow or applying filters earlier in the chain can help distribute the load more evenly.
I would also take a moment to thank rajendraongole1, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.