Forum Discussion

Regular Visitor

9 months ago

Solved

Data Load Issue using Multiple tables append and Multiple left merge queries

Hi Team, I'm facing issue while merging queries in Power BI. I have applied multiple appeend queries and merge Queries. Data source is two different i.e Azure Databricks and Sharepoint Folder. ...

Need Help

v-saisrao-msft
9 months ago
Hi Nisha_Goyal,

Please try using a Power BI Dataflow in the service to perform your merges and appends this can help offload the heavy processing from Power BI Desktop and may resolve the memory allocation issue.

Memory error: Memory Allocation failure. Try simpl... - Microsoft Fabric Community

Solved: Memory error: Memory Allocation failure on Power b... - Microsoft Fabric Community

Thank you.

v-saisrao-msft

Community Support

9 months ago

Hi Nisha_Goyal,

Please try using a Power BI Dataflow in the service to perform your merges and appends this can help offload the heavy processing from Power BI Desktop and may resolve the memory allocation issue.

Memory error: Memory Allocation failure. Try simpl... - Microsoft Fabric Community

Solved: Memory error: Memory Allocation failure on Power b... - Microsoft Fabric Community

Thank you.

Forum Discussion

Data Load Issue using Multiple tables append and Multiple left merge queries

Related content

MULTIPLE CARD

Merging Multiple Queries

Multiple dataViewMappings

Power Query Combine Multiple Files From Folder

Merge data from multiple excel files from multiple sharepoint folders