Forum Discussion
Advocate IImporting M Power Queries from Excel 2016 into Power BI
Community ChampionLooks like you loaded the spreadsheet from Get Data? That's an entirely different workflow. What I was suggesting is to just copy and paste your query group from one Query Editor to the other. Right click on "Beginner Queries" in the Excel query editor and select Copy. Then right click in the query pane in Power BI and select Paste,
Advocate IMy bad, thanks! Got it now. It works.
But there is no way to share queries with other users, say, if I wanted to share my queries with you or vice versa?
The solution you described only works on one and the same system.
- otravers
Correct, what I gave you is a single-user desktop shortcut.
You can share queries in the Azure data catalog from Excel, but that's not supported as a query source directly from Power BI Desktop, even though you need a Power BI Pro license to post queries from Excel to Azure Data Catalog!
Excel 2016 screenshot:
But then in Azure Data Catalog the "Open In" menu is greyed out:
Normally it should list Power BI Desktop like in the example below (which is a SQL source, not a PQ query):
Frankly the whole experience is very confusing, I've found ADC very slow, and it feels like they stopped development in the middle of doing it. Feels like a poor handover from the Office team to the Azure team that can only make sense to insiders within the involved teams.
See this thread:
And this thread:
https://community.powerbi.com/t5/Desktop/Data-catalog-integration-with-Power-BI/td-p/235160