Connect to a XMLA Endpoint with Python

[AlexisOlson]

Since the announcement about XMLA endpoints, I've been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] via Python, but I can't find anything that works.

I have a workspace in a premium capacity and I am able to connect to it using DAX Studio as explained here, but I haven't figured out how to do it with Python. I've tried installing olap.xmla, but I get the following error when I try to use the Power BI URL as the location using either the powerbi or https as the prefix.

import olap.xmla.xmla as xmla
p = xmla.XMLAProvider()
c = p.connect(location="powerbi://api.powerbi.com/v1.0/myorg/[My Workspace]")
[...]
TransportError: Server returned HTTP status 404 (no content available)

I'm sure there are authentication issues involved, but I'm a bit out of my depth here. Does anyone know of any blog posts or other resources that demonstrate how to connect to a Power BI XMLA endpoint specifically using Python? My searching has failed me, but surely I can't be the only one who is trying to do this.

[v-yuta-msft]

@AlexisOlson ,

This error should caused by invalid URL or workspace, please refe to power bi rest api for more details.

https://docs.microsoft.com/en-us/rest/api/power-bi/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

@v-yuta-msft 

I'm using exactly the same URL that works with DAX Studio, so that doesn't seem like it would be the problem.