Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning everyone.
new user of Power BI here.
I have started a new job and am looking to connect to their full suite of API's so i can create some dashboards.
i can access the API's already using Postman but am struggling on what i need to do within Power BI to get the data.
Essentially there is an identity server where i first have to get a bearer token in order to access the API
i have tried using the Web method for get data and adding the URL but it errors with authorisation
i have looked at using the advanced editor when using the blank query but again unsure how to add the access credentials in
can anyone offer some wisdom
thanks
Daryl
Solved! Go to Solution.
@DarylCox , refer if this can help
https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/
So cant seem to get the second part working to automatically refresh the token each time.
i have followed the steps in the link but i get an error.
this is the query
but this is the response i get
i know the URL is correct as it works in Postman and i get a valid token.
could it be to do with these elements i have set in Postman
@DarylCox , refer if this can help
https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/
Many thanks for this.
managed to connect to the API, just struggling with the final part to automatically refresh the token each time.
i am suspecting it is because i have another parameter of tenant to include so will keep trying
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |