Use REST API as datasource with service principal

[AslanAli]

Hi guys,

We want to use REST API of Power BI directly in Power BI Desktop and not via PowerShell.

I have a service principal which works in PowerShell.

How can I use REST API directly in Power BI Desktop with authenticating with a service principal.

Good to mention: I don't want to save the username and password a query.

[Anonymous · Accepted solution]

Hi  @AslanAli ,

I think you can try below code to get access token by Rest API with Service Principal.

() =>

 

let

    body = "client_id=" & #"App ID"

    & "&scope=https://analysis.windows.net/powerbi/api/.default&client_secret=" & #"App Secret"

    & "&grant_type=client_credentials",

    Data= Json.Document(Web.Contents("https://login.microsoftonline.com/"& TenantID & "/oauth2/v2.0/token/",

    [Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])),

    access_token = Data[access_token]

in

    access_token​

Then add this token as a parameter into data source code. You may refer to below video to learn more details.

Video: How to get access token and call Rest API by dynamic access token in Power BI Desktop?

Best Regards,
Rico Zhou

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

[lbendlin]

GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector fo...