topic Re: Connecting API - Power BI - Client Credentials in Developer

Connecting API - Power BI - Client Credentials

uma_mahi — Fri, 10 May 2024 15:05:04 GMT

Hi Team ,
Can you please help me how to pass the below query in Power Query and Is it possible to pass the below request in Power BI? Is there any tutorial which explains about the API and how it works with Power BI? Please guide me on this.
access_token_response = requests.post('https://api.xxx.com/auth/connect/token',

headers={'Content-type': 'application/x-www-form-urlencoded'},

data={ 'client_id': '1232cd11-7862-1111-83c2-28f5a0b6ce0a', 'client_secret': 'QopQopQop133111', 'grant_type': 'client_credentials', })

access_token = access_token_response.json().get('access_token')

print("Access Token", access_token)

accounts_response = requests.get('https://web-api.xxx.com/enterprise/v1/accounts',

headers={ "Accept": "application/json", "Authorization": f'Bearer {access_token}' })
Thanks!

Re: Connecting API - Power BI - Client Credentials

Anonymous — Mon, 13 May 2024 01:38:03 GMT

HI @uma_mahi,

You can try to use the following M query codes if they help for your scenario:

let url = "https://web-api.xxx.com", body = "{ 'client_id': '1232cd11-7862-1111-83c2-28f5a0b6ce0a', 'client_secret': 'QopQopQop133111', 'grant_type': 'client_credentials'}", token_response = Web.Contents( url, [ RelativePath = "/auth/connect/token", Headers = [#"Content-Type" = "application/x-www-form-urlencoded"], Content = Text.ToBinary(body) ] ), access_token = Json.Document(token_response)[access_token], accounts_response = Web.Contents( url, [ RelativePath = "/enterprise/v1/accounts", Headers = [Accept = "application/json", Authoraztion = "Bearer " & access_token] ] ), Result = Json.Document(accounts_response) in Result

Regards,

Xiaoxin Sheng