Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @mim,
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.
Thanks,
Lydia Zhang
Any updates
Here you have your answer:
https://freesbi.wordpress.com/2022/01/11/conexion-en-modo-import-a-un-dataset-de-power-bi-publicado/
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.
As of this month, yes. It is a new preview feature for April:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-lifecycle-datasets/
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.
cheers
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)
http://exceleratorbi.com.au/direct-connect-excel-power-bi-service/
http://exceleratorbi.com.au/excel-workbook-connection-local-power-bi-desktop/
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.
Hi @mim,
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.
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |