Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Probably a beginner question here.
Trying to access a third party vendor API (GET). It requires an authorization token based on user supplied ID and password through a PUT API. Is there a way to use a Power BI query to get the authorization token. Once that is done is there a way to ensure it is dynamically included in the power BI query GET API? I think I need to include the PUT in the header somehow, but I am not able to figure this out.
The PUT API is structured as follows:
URL: https://xxxxx.xxxxx-put.com/api/Auth/Login
Request Type: PUT
Parameter Content Type: application/json
Body Parameters:
{
"Username": "string",
"Password": "string",
}
Response: {
"Data": {
"access_token": "xbxbssgdgdgdgdgdggdgd",
"token_type": "bearer"
},
"KeyValue": null,
"IsSuccessful": true,
"Errors": null
}
The get API is as follows
https://xxxxx.get.com/api/General/GetData
Any help is greatly appreciated
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |