Get Power Query For Excel 2016 License To Post

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.

Is there a workaround Any feedback highly appreciated.

I have a NEW book DAX Cookbook from Packt Over 120 DAX Recipes Did I answer your question Mark my post as a solution Proud to be a Super User.

Ive tested this between Excel, Power BI, and Visual Studio (SSAS).

But what I see then is this I am not qute sure what to do with this.

What I was suggesting is to just copy and paste your query group from one Query Editor to the other.

Then right click in the query pane in Power BI and select Paste.

Get Power Query For Excel 2016 License To Post

You can share queries in the Azure data catalog from Excel, but thats 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, Ive 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.

Get Power Query For Excel 2016 Mac