Power BI Admin API Connection via MQuery

[QS7]

Hi,

I am currently trying to build a report based on the Admin PBI.
However i can't find a way to connect to the API by using Power Query ( I can't use PowerShell ).
Once the app is registred, is there a way to retrieve the Token with Power Query then make an API call ?
I also saw the custom connector however i'm not allowed to enable the 'Allow any extension to load without validation or warning' option.
( I already done something similar but using Data Factory by using a service principal but it doesn't seems to be working for Power BI )

[v-chenwuz-msft · Accepted solution]

Hi @QS7 ,

Here's one detailed explanation

Call Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API | Part Two

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.