Forum Discussion
Power Query | Migrating from Excel to Power BI
Hi,
Is there an easy/elegant way to migrate my Power Query from Excel to PowerBI? Or do I have to re-do them?
What you could do is to import your Excel file directly into Power BI Desktop.
In doing so you will have all your Power Query information as well as measures imported into Power BI Desktop.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/
4 Replies
What you could do is to import your Excel file directly into Power BI Desktop.
In doing so you will have all your Power Query information as well as measures imported into Power BI Desktop.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/
Life-saver! Done and successful!
I love you for answering my question more than 7 years before I needed to ask it and for saving my bacon 😁
This is not working for our Team, we have stored the Excel on a SharePoint Documents Library. To Open the Excel it uses the File Explorer, it is possible.
Error: File Explorer: 'Windows can't find 'https://sites.X.com/sites/Y... Check the spelling and try again.' I don't know it is blocked by our organisation or by Microsoft!
