Forum Discussion

Amisha's avatar
Amisha
Frequent Visitor
4 years ago

Error regarding memory consumption.

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

Tips and Tricks

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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