Forum Discussion
DM_GWPipeline_Client_MaxPacketLimitReached
Hi Narendra24488 ,
Since the issue occurs when fetching more than 200,000 rows, consider implementing pagination in your report. Fetch smaller chunks of data at a time to avoid hitting the limit.
Ensure that your query is optimized to fetch only the necessary data. Consider applying more specific filters or reducing the number of columns if possible. This can significantly reduce the data size being processed.
Enable query folding, which means that Power BI converts queries into more efficient forms that can be executed directly on a data source, such as SQL Server.
Below is the official link will help you:
Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Narendra24488 ,
Since the issue occurs when fetching more than 200,000 rows, consider implementing pagination in your report. Fetch smaller chunks of data at a time to avoid hitting the limit.
Ensure that your query is optimized to fetch only the necessary data. Consider applying more specific filters or reducing the number of columns if possible. This can significantly reduce the data size being processed.
Enable query folding, which means that Power BI converts queries into more efficient forms that can be executed directly on a data source, such as SQL Server.
Below is the official link will help you:
Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.