Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.