Forum Discussion
Migration Failed
I have a large Microsoft Excel (365) spreadsheet: 29 Columns wide with 87,317 rows. This information is located on sheet 1 in table format. Sheet 2 contains a pivot table and 22 slicers. As you can imagine, it lags quite a bit in excel. I have tried to import this file into Power Bi and keep getting the following message "The following Excel workbook doesn't contain any queries or a model to import: C:\yada, yada, yada..................I have searched for an answer in google but the only answer I can find is the data should be formatted as a table. My data is formatted as a table yet still the Migration Fails.
6 Replies
You don't really need to worry about sheet2.
For sheet1 - does it have a defined table (header row and data rows with alternating background color) is it just the raw data on the sheet (all white background) ?
It is a defined table format with all white background. There are different formats within cells, number format for fractions, etc.
I have removed the pivot table, deleted all slicers and deleted sheet 2. I have also cleared all formatting on sheet 1 and reformatted all data into a table again. Still receive "Migration Failure" message
Should I still import as "Power Query, Power Pivot, Power View"? The slicers I had in excel were the most important part of my workbook so I will need to add something similar in Power BI
Would you be able to post a sample Excel file?
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Thanks for lbendlin's concern about this issue.
Hi, NUCMECHPLANNER
I am glad to help you.
Can I ask if your data is in the original Excel sheet or from another data source?
Have you tried breaking your data into smaller sections and then importing them into Power BI incrementally? This could help you determine if the volume of data is causing the problem.
You can try storing your files on OneDrive or SharePoint and then using the links to those platforms to import the data instead of the local file path.Or you can also check the version of Power BI Desktop and Excel you're using to make sure you're using the latest version of Power BI Desktop and Excel.Sometimes, newer versions fix some compatibility issues.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
