Forum Discussion
Solved
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/
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!