blog icon indicating copy to clipboard operation
blog copied to clipboard

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

Open utterances-bot opened this issue 5 years ago • 8 comments

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

utterances-bot avatar Dec 12 '20 05:12 utterances-bot

Great post!

jdfancke avatar Nov 06 '22 17:11 jdfancke

Can this work on Linux or Mac?

crux-unni avatar Nov 11 '22 14:11 crux-unni

Can this work on Linux or Mac?

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

pawarbi avatar Nov 11 '22 17:11 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

darrannorman avatar Dec 04 '22 02:12 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

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

pawarbi avatar Dec 11 '22 03:12 pawarbi

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

tttt-ad avatar Jun 01 '23 19:06 tttt-ad

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

error404compiled avatar Sep 16 '23 06:09 error404compiled

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

sollama24 avatar Nov 01 '23 23:11 sollama24