Memory error: Memory Allocation failure. Try simplifying or reducing the number of queries.

Hi  Anonymous ,

It sounds like you are running into a memory allocation issue when trying to import a large amount of data into Power BI Desktop from a Power BI Dataflow. One potential solution would be to simplify or reduce the number of queries that you are using to import the data.

Another option would be to try and optimize the queries themselves to reduce the amount of memory required to import the data. This could involve filtering the data in the Power BI Dataflow before importing it into Power BI Desktop, or reducing the number of columns that you are importing.

You could also try increasing the amount of memory available to Power BI Desktop by adjusting the memory settings in the Options menu. However, this may not be a viable option if you are working with limited resources.

Finally, you could consider breaking up the data into smaller chunks and importing it into Power BI Desktop in stages. This would allow you to work with the data in smaller, more manageable pieces and avoid running into memory allocation issues.

Best regards.
Community Support Team_Caitlyn