topic Re: Use REST API as datasource with service principal in Developer

Use REST API as datasource with service principal

AslanAli — Fri, 02 Dec 2022 14:25:17 GMT

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.

Re: Use REST API as datasource with service principal

lbendlin — Sat, 03 Dec 2022 20:32:08 GMT

GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API

Re: Use REST API as datasource with service principal

Anonymous — Mon, 05 Dec 2022 06:44:43 GMT

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.