topic Python PowerBI access to published PowerBI App in Developer

Python PowerBI access to published PowerBI App

Anonymous — Fri, 06 Aug 2021 09:00:10 GMT

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

Re: Python PowerBI access to published PowerBI App

lbendlin — Fri, 06 Aug 2021 16:53:57 GMT

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

Re: Python PowerBI access to published PowerBI App

Anonymous — Fri, 13 Aug 2021 08:43:55 GMT

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.

Re: Python PowerBI access to published PowerBI App

lbendlin — Fri, 13 Aug 2021 12:12:47 GMT

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

Re: Python PowerBI access to published PowerBI App

Anonymous — Tue, 17 Aug 2021 11:15:07 GMT

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

Re: Python PowerBI access to published PowerBI App

lbendlin — Tue, 17 Aug 2021 11:17:52 GMT

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

Re: Python PowerBI access to published PowerBI App

Anonymous — Tue, 17 Aug 2021 11:27:22 GMT

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

Re: Python PowerBI access to published PowerBI App

lbendlin — Tue, 17 Aug 2021 11:31:47 GMT

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

Re: Python PowerBI access to published PowerBI App

lbendlin — Tue, 17 Aug 2021 11:50:48 GMT

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.