Accessing Power BI Datasets via XMLA Endpoint in Python Jupyter Notebook | Sandeep Pawar

[utterances-bot]

Accessing Power BI Datasets via XMLA Endpoint in Python Jupyter Notebook | Sandeep Pawar

In this blog post I show how you can use Python to access datasets published to Power BI service using Python in Jupyter Notebook

https://pawarbi.github.io/blog/ppu/xmla/powerbi_premium/premium/python/jupyter_notebook/2020/12/11/Accessing-Power-BI-Datasets-via-XMLA-Endpoint-in-Python-Jupyter-Notebook.html

[jdfancke]

Great post!

[crux-unni]

Can this work on Linux or Mac?

[pawarbi]

Can this work on Linux or Mac?

I am not sure about that because it needs those ADOMD DLLs which are Windows specific.

[darrannorman]

Great post. All working for me until I try to execulate a dax query. I get a the following error: AuthenticationException: Unable to obtain authentication token using the credentials provided. ---> Microsoft.Identity.Client.MsalClientException: There was an error parsing WS-Trust response from the endpoint.

any ideas? Really appreciat any thoughts

[pawarbi]

Great post. All working for me until I try to execulate a dax query. I get a the following error: AuthenticationException: Unable to obtain authentication token using the credentials provided. ---> Microsoft.Identity.Client.MsalClientException: There was an error parsing WS-Trust response from the endpoint.

any ideas? Really appreciat any thoughts

That's weird because I am not using an access token. It should let you authorize interactively.

[tttt-ad]

Thank you so much for the post. great help for me so far. I wonder if anyone encounters the error 'The 'BC88062A-18F1-4A80-899E-15A638925AB7' session ID cannot be found. Either the session does not exist or it has already expired

[error404compiled]

Can I do this without using the dll or loading.net assamble And why are we using that ?

[sollama24]

Does this feature allow you to connect with live datasets that others in your organization created?