topic Re: Power BI Admin API Connection via MQuery in Developer

Power BI Admin API Connection via MQuery

QS7 — Wed, 15 Jun 2022 15:20:40 GMT

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 )

Re: Power BI Admin API Connection via MQuery

v-chenwuz-msft — Mon, 20 Jun 2022 07:59:58 GMT

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.