New to power bi, need help on authentication via api

[pixelatedpic]

Hi,

I am new to Power Bi and its REST API. I have tried to authenticate using API from Postman software and from browser too but no luck yet.

What i am trying to do is below.

1- I have created a push dataset in power bi.

2- I want to push data to power bi dataset from php or python script.

I am not able to do that and dont know any easy method. I have used REST API for many softwares but this one is not so familiar and dificult. So please guid me an easy way that i can test this from postman software and enjoy this great software(Power Bi)

Hope to get a reply ASAP.. thanks

[Eric_Zhang · Accepted solution]

---

@pixelatedpic wrote:

Hi,

I am new to Power Bi and its REST API. I have tried to authenticate using API from Postman software and from browser too but no luck yet.

What i am trying to do is below.

1- I have created a push dataset in power bi.

2- I want to push data to power bi dataset from php or python script.

I am not able to do that and dont know any easy method. I have used REST API for many softwares but this one is not so familiar and dificult. So please guid me an easy way that i can test this from postman software and enjoy this great software(Power Bi)

Hope to get a reply ASAP.. thanks

---

@pixelatedpic

To authenticate via REST API, the first step is to Register an app with Azure AD. Then you can make a POST call as

POST /common/oauth2/token HTTP/1.1
Host: login.windows.net
Cache-Control: no-cache
Content-Type: application/x-www-form-urlencoded

client_id={registered native client app id}&grant_type=password&resource=https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi&username={your power bi account}&password={your password}

The response JSON contains the access token