Forum Discussion
Advocate IImporting M Power Queries from Excel 2016 into Power BI
I wrote several M Power Queries in Excel, and I want to import those into Power BI.
These queries are connections only, they are not loaded as tables into my Excel workbook.
In case of a workbook, the corresponding M Power Queries get loaded into Power BI.
But I only need the M Power Queries.
Is there a workaround?
Any feedback highly appreciated. Thanks!
9 Replies
- Greg_Deckler
Community Champion
Hmm, I can't find any way to get to the underlying "M" code for queries in Excel. If you could, then it would be a simple copy and paste into the Advanced Editor.
- RafaelKnuth
Thanks, there are some limits to copy and paste thogh, as I want to import Queries by the dozens ;-) So, this certainly works with few Queries, but that workaround becomes hugely error-prone when juggling with many Queries at once.
- otravers
Put your queries in a folder, then copy and paste the whole folder. I've tested this between Excel, Power BI, and Visual Studio (SSAS). See this thread and its screenshots where I show where in the UI you can do it:
