Forum Discussion
Issue with getting data via API with bearer token
Hi, I am using an API that requires a bearer token embedded in the header that has a 30 min lifespan. I have constructed a Power Query ("M") that will pass the username and password to a Microsof...
Hi aexley,
Have you tried with Bearer (in capital letters)? I spent hours with that and finally that was the stupid problem.
Now, my big problem is that this solution does not work me on the Power BI service.
Good luck!
jlorenzo kailashkrishnan Anonymous thanks for your input.
Just realised there had been further commentary on this so I thought I'd better close out with my resolution.
jlorenzoI had the same issue. Managed to get the functionality to work from Desktop, but when you push to service, it has authorization issues.
My workaround that I settled on was to make Azure Functions for the API calls which I have scripted in C# then I call the Azure Function as an API.