Forum Discussion

RafaelKnuth's avatar
RafaelKnuth
Icon for Advocate I rankAdvocate I
8 years ago

Importing 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 workboo...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
RafaelKnuth's avatar
RafaelKnuth
Icon for Advocate I rankAdvocate I
8 years ago

My 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's avatar
otravers
Icon for Community Champion rankCommunity Champion
8 years ago

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:

https://community.powerbi.com/t5/Desktop/Ways-to-share-Power-Query-queries-between-PBI-Excel-SSAS-Copy/m-p/296462#M130802

 

And this thread:

https://community.powerbi.com/t5/Desktop/Data-catalog-integration-with-Power-BI/td-p/235160