I Know about analyze in Excel but i am after PowerQuery ?
Go to Solution.
It is not possible to connect to Power BI Service dataset from Power Query as you described, regarding to this issue, you can submit an idea in Power BI Ideas forum.
As of this month, yes. It is a new preview feature for April:
Proud to be a Datanaut!
Thanks, I was not clear, I want the connection from Excel/Powerquery
the analyze in Excel works live, what i am looking after, is to use Excel/PowerQuery to connect to PowerBI service and select some measures dimensions, the way we can do right now in SSAS on premise.
If you install the PBI Publiher for Excel you can connect to the PBI Service as described here
Here are 2 other links you can check out (1 to connect to the PBI Service and 1 to Local PBI)
Hope this helps!
@Sean I am very familiar with that approach, but it is a live connection, I want to to connect to PowerBI service from Excel using Powerquery then load the tables in the local PowerPivot Data model.
after all it should be doable the PowerBI service is just a SSAS under the hood, the connections is using https though, which i am not sure how to use it using Powerquery.
thanks for your reply.
I have the same need. No news on this anoyone? I can do this with other SSAS cubes but cannot figure it out for PBI.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!