Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am experiencing an issue with a dataflow refresh in my Power BI Premium Per User workspace and would appreciate some insights or solutions.
During the refresh process, I received the following error: "Error: PipelineException: Array dimensions exceeded supported range." This error occurs when refreshing a specific data flow.
Could anyone explain what might be causing this error and suggest potential solutions?
Solved! Go to Solution.
Hi @NoorAlfar
Based on the error message you provided, it seems that the array dimension is out of support. This can be due to a document that is too large or a query that is too complex. This error is related to the . .NET architecture.
Here are some possible workarounds:
Divide the document into smaller chunks and process them separately. This has the potential to reduce memory consumption and array size during the refresh process.
Simplify the query or remove some unnecessary steps.
In some cases, updating a full copy of the source data with each refresh is time-consuming. You can consider incremental refresh.
You can view the link below for more details:
Using incremental refresh with dataflows - Power Query | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NoorAlfar
Based on the error message you provided, it seems that the array dimension is out of support. This can be due to a document that is too large or a query that is too complex. This error is related to the . .NET architecture.
Here are some possible workarounds:
Divide the document into smaller chunks and process them separately. This has the potential to reduce memory consumption and array size during the refresh process.
Simplify the query or remove some unnecessary steps.
In some cases, updating a full copy of the source data with each refresh is time-consuming. You can consider incremental refresh.
You can view the link below for more details:
Using incremental refresh with dataflows - Power Query | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.