Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi guys,
I set up a token code to get data from a privet API in POWER BI.
How the code work is from the main URL I get access to toking and under the main URL, I can specify the sub-toke URL with a unit ID number.
The problem is I can use this method to get access to one sub-token instead two or more. The main reason is when I run the code the main URL can be used for one sub-token. I tried to duplicate the code and plagued the different client IDs and client secrets with the main URL but as I said the main URL worked just for one.
Is there anyone who can help me with this problem?
let
url = "main URL",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username="<user_name>",
password= "<password>"]),
response = Web.Contents(
url,
[
ApiKeyName="api_key",
Headers = headers,
Content = postData
url2 = "sub_url_12344",
headers2 = [#"Content-Type" = "application/json",#"Authorization"="Bearer " & Value1],
//postData = Text.ToBinary("grant_type=client_credentials&client_id=vvvvvv&client_secret=12345"),
]
),
jsonResponse = Json.Document(response)
in
JSON response