Forum Discussion
Solved
Get Bearer Token Via Power Query to Interrogate Power BI APIs
I would like to build a Power BI report based on data about my Power BI tenant via the Power BI APIs (unless of course there is another way to report directly on the tenant content...), and I can do ...
The only other approach I see then is to set up an Azure function which gets the auth for you.
The "easy" answer is to build your own connector which will give you access to the APIs to do this. However, you won't be able to do online refresh unless you get it certified.
Thanks, but ideally I would like to avoid building a custom connector, as it then has to be supported by my organisation.
A couple of points of clarity to help: I would like to access the Power BI APIs via Power BI Service Dataflows, and also I have to use multi factor authentication in our organisation.
Thanks,
Joe
The only other approach I see then is to set up an Azure function which gets the auth for you.