topic Re: Connecting to API in Developer

Connecting to API

Anonymous — Fri, 25 Feb 2022 09:50:26 GMT

Hi experts,

I am trying to connect PowerBI to API. I a doing this for the first time, so not sure how to proceed. Looking for your guidance.

This is the URL I am trying to connect.

https://login.microsoftonline.com/ea80952e-a476-42d4-aaf4-5457852b0f7e/oauth2/token

I have the following details:

1. client_id = 'c*****a'
2. client_secret = 'r********e'
3. resource= 'f********9'

4. grant_type=client_credentials

I am trying to provide the details as

Getting the below error.

Getting the response from Postman.

Please advise.

Thanks.

Re: Connecting to API

ghumarepratik21 — Fri, 25 Feb 2022 10:00:34 GMT

Hello,

You will require authentication key for that API to use header. If you have details you can enter and issue will get resolved.
For refrence you can check below link,
https://www.google.com/search?q=connect+api+with+power+bi&rlz=1C1YQLS_enIN975IN975&oq=connect+api+with+power+bi&aqs=chrome.0.0i512j0i22i30l3.4737j0j4&sourceid=chrome&ie=UTF-8#kpvalbx=_86cYYpb_GIq75OUP8-ahiA819

Thanks,
Prateek G

Re: Connecting to API

Anonymous — Fri, 25 Feb 2022 11:12:49 GMT

Thanks @ghumarepratik21. for the response. I have the client_secret which should be the API key, i believe. Anyways, I will check on this line.

Thanks.

Re: Connecting to API

Anonymous — Wed, 02 Mar 2022 02:31:02 GMT

HI @Anonymous,

AFAIK, these types of parameters(e.g. client id, secret) will be transformed into a binary string and attached to the httprequest 'content' part instead of directly sending the original string from the httprequest header.

let url = "https://login.microsoftonline.com/xxxxxxx/oauth2/token", GetJson = Web.Contents( url, [ Headers = [ Accept = "application/json", ContentType = "application/x-www-form-urlencoded" ], Content = Text.ToBinary( "grant_type=client_credentials& client_id=xxxxxxx& client_secret=xxxxxxx& scope=xxxxxx" ) ] ), token = Json.Document(GetJson)[access_token], Result = Web.Contents( "https://xxxxx.xxx.com", [ Headers = [ #"Content-Type" = "application/json", Authorization = "Bearer " + token, RelativePath = "/xxxxx/xxxxx" ] ] ) in Result

Regards,

Xiaoxin Sheng

Re: Connecting to API

Anonymous — Wed, 02 Mar 2022 11:18:09 GMT

Thanks @Anonymous for your inputs. Will explore on this.

Re: Connecting to API

Anonymous — Wed, 02 Mar 2022 13:57:06 GMT

Go to Data source settings, Select the connection from the list to which you are connecting. Click on edit permissions and check it's set to anonymous, if not then set it to anonymous.

Re: Connecting to API

Anonymous — Wed, 02 Mar 2022 14:57:47 GMT

@Anonymous that is a great suggestion, I was able to move to the next stage, but encountering a different issue. Is this something to do with the parameters I am passing? Any suggestion on this?

This is the screenshot of parameters I'm passing.

This is the error I am getting

Re: Connecting to API

Anonymous — Thu, 03 Mar 2022 06:49:10 GMT

@Anonymous Try to do it from advance editor query and Put the code as below. Power BI is taking your request as a GET request instead of POST request so you need to create it as a post request.

You are passing these values in Headers but these should be passed in the body part.

Re: Connecting to API

Anonymous — Thu, 03 Mar 2022 13:15:44 GMT

Thank you @Anonymous, I will check this and get back.

Re: Connecting to API

Anonymous — Mon, 07 Mar 2022 12:30:04 GMT

@Anonymous did it work for you?

Re: Connecting to API

Anonymous — Mon, 07 Mar 2022 12:40:19 GMT

@Anonymous I had encountered some other issue. So i created it as a function and called the function.

Re: Connecting to API

Anonymous — Mon, 07 Mar 2022 13:46:19 GMT

@Anonymous Great, the idea was only to pass the credential in the body and not in header as you were doing earlier.

Re: Connecting to API

Anonymous — Mon, 07 Mar 2022 13:50:52 GMT

@Anonymous totally agree, that was a wonderful pointer.. accepting this as a solution. One should not pass credential in the header but should be passed along in the body.

Thank you!

Re: Connecting to API

vannda21 — Tue, 14 Jun 2022 02:49:14 GMT

Hello @Anonymous ,
Does it work for you now?