How to get data from a source using tokens as authentication?

Question

HelloI need to make reports based on data from an API that can only be accessed using authentication tokens.&nbsp;I couldn't find a way to import data using this option. I could see only basic authentication as an option.Also, if I upload the dashboard to Powerbi Service, how will the data be updated on a regular basis, since the token would expire every few hours?

lbendlin · Answer

write your own connector
&nbsp;
Handling authentication for Power Query connectors | Microsoft Docs

anonymous · Answer

Hi&nbsp;Anonymous,
I'd like to suggest you check the below link about use web connector to get data from the rest API with authentication:
Solved: Pull data from a REST API Authentication - Microsoft Power BI Community
Regards,
Xiaoxin Sheng

anonymous · Answer

Hi&nbsp;Anonymous,
Any update for these?&nbsp;
For the expired issues, you can add the get token processings into the query table steps instead use static token strings, then it will invoke to get the vailed token every time the scheduler refresh triggered.
Regards,
Xiaoxin Sheng

Forum Discussion

How to get data from a source using tokens as authentication?

3 Replies

Related content

REST API Silent Authentication (Token)

Authentication and Query issues - cannot authenticate, queries hang

Expression.SyntaxError: Token ',' expected.

Snowflake cloud connection: KeyPair authentication

Power BI Service Refresh Failure: OAuth authentication method isn't supported for this data source