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.
