Error regarding memory consumption.

[Amisha]

Hello everyone,

I want to export 10 MB power bi dataset into excel. But when I try to close and load the data from power query in excel it throws the following error which I have attached with this message. 

Please help me out with this problem.

Thanks and Regards,

Amisha

[v-kkf-msft]

Hi @Amisha ，

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @Amisha ,

Are you using Excel to connect to the dataset on the Power BI Service? What is your excel version?

Have you tried to use the "Analyze in Excel"? With Analyze in Excel, you can bring Power BI datasets into Excel, and then view and interact with them using PivotTables, charts, slicers, and other Excel features.

Or you can refer to the following document to resolve available resources errors in excel.

How to troubleshoot "available resources" errors in Excel 

"Excel cannot complete this task with available resources" error occurs in Excel 2010 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.