Power Query | Migrating from Excel to Power BI

[ovetteabejuela]

Hi,

Is there an easy/elegant way to migrate my Power Query from Excel to PowerBI? Or do I have to re-do them?

[EYbebxcmoecroSP]

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!

[GilbertQ · Accepted solution]

Hi @ovetteabejuela

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/

[faysanderson]

I love you for answering my question more than 7 years before I needed to ask it and for saving my bacon 😁

[ovetteabejuela]

Life-saver! Done and successful!