Python PowerBI access to published PowerBI App

[Anonymous]

HI all,

I am trying to access a published PowerBI report via Python. Hence I am facing some issues with the correct login to the report which is located at the page 'https://apps.powerbi.com/groups/me/apps/...'.

I know that this is a basic question. I have tried to use the Python library adal, however there is some issues with this.

I found this https://bitbucket.org/omnistream/powerbi-api-example/src/master/ but the login there is to the api and not to the app.

I was wondering what the best way is to do  

[Anonymous]

I am searching for an option to login via my Azure account to an embedded PowerBI dashboard, not to the PowerBI data set itself.

[lbendlin]

understood. But since you are already using Selenium you could also consider bypassing/emulating the login through mouse clicks.

[lbendlin · Accepted solution]

If you use Selenium or Workfusion or any other RPA tool, what do you need Python for?  Scripting the clickthrough path?

[Anonymous]

Thanks for your answer.

I need to access PowerBI via Python + Selenium and want to test the embedded report into a web page. Because of that I do not want to access the dataset itself.

[lbendlin]

As I said earlier this is not a good requirement. Rethink what you are ultimately trying to accomplish.

[Anonymous]

That is the best way how to test "normal" user behaviour and hence I cannot rethink it.

[lbendlin]

You bring up a good point though.  At the moment Power BI does not have any testing capabilities that you might expect from a standard development environment where writing test scripts is part of the process.  It might be worth raising this as an idea/requirement to see if anyone else would be interested.

[lbendlin]

I got that same question internally the other day.  What forces your python app to connect to a Power BI dataset rather than to the original underlying data source?  Power BI should not be a source system as it is not the system of record.

Anyway, here's the documentation:

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs