Forum Discussion
Getting data via REST API using Bearer as Authentication token
Resident RockstarHi Anonymous ,
If I understand your scenario correctly that you want to pull data via Rest API with GET Method and have authorization token as Bearer token.
If so, you could refer to the similar threads and blogs below firstly.
https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006
If you still need help, feel free to ask.
Best Regards,
Cherry
Hi v-piga-msft ,
Thanks for the response. I managed to figure out, the authorization token , we need to just add the text of Authorization type.So it works now if I pass the Authorization header as Bearer Token--xxx-xxx-id.
The above api give me the overall result, however I am still stuck when I try to append my filter value of start and end date in my api as ../.../api/v1/data?startdate= 01-01-2012&enddate=02-02-2017. This runs fine in Postman but in Power Bi i get error as 400 Bad request. Any other way to handle the filters and is there any way to pass the date dynamically??Thanks again.
Ankku
gilbertendayaHelper IV
hi Anonymous can you advise how did you work on Authorization bearer?
I'm having the same problem.
Authentication error.