Forum Discussion
How Power BI Using Access Token & Secret to my Platform API
Hi all Power BIers,
I want to access platform data using platform API provided by developer. It has API endpoint, access token ID, and token secret. How do I use Power BI to access the dataset? I tried Get Data -> Web -> Basic -> entering access token as username & secret as password. Error is Details: "Web.Contents failed to get contents from 'https://xxx (404): Not Found". Is this the right way to do this?
Also, another way to access the platform data is Authentication using basic auth
GET /query/results/019dfda3-3338-4110-3cf5-31433d75e6da HTTP/1.1
Authorization: Basic base64(ACCESS_TOKEN_ID:ACCESS_TOKEN_SECRET)
Does Power BI support this? If so, how do I achieve it?
Thanks in advance.
Hi Anonymous ,
You could reference the blog to learn how to connect API with acess token.
https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
3 Replies
AM , thanks for the resources. I don't think I explain my issue correctly. My data resides in a proprietary data repo where a platform API is provided. Access token and secret are available for external tools like Power BI to access and visualized the data after authentication. I can import Appannie data ok via Get Data -> Web without programming, just specifying authorization parameters. Embedded Playground seems like an overkill. Any other idea on how this can be done in Power BI?
Thanks in advance.
Hi Anonymous ,
You could reference the blog to learn how to connect API with acess token.
https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
