Forum Discussion
How to determine by data from web uses OAuth2 or API key
This might be a very silly question. I have connected to a WEB data using Authorization header and Basic xxxxxxxxxx. Is this OAuth2 type authentication or API authentication?
Hi Anonymous
It's not OAuth as that requires that you first get a 'token' (code) before making a connection to the system to retrieve data.
An API is just a programmable means to retrieve data from a system and an API can can require several forms of authentication, it depends on the system.
An OAuth system is an API but so is a system that just requires a simple username/password combination.
These articles should help shed some light on the types of API's and types of authentication
Getting Started with API's in Power Query • My Online Training Hub
Connecting to an OAuth API Like PayPal With Power Query • My Online Training Hub
Regards
Phil
4 Replies
Hi Anonymous
It's not OAuth as that requires that you first get a 'token' (code) before making a connection to the system to retrieve data.
An API is just a programmable means to retrieve data from a system and an API can can require several forms of authentication, it depends on the system.
An OAuth system is an API but so is a system that just requires a simple username/password combination.
These articles should help shed some light on the types of API's and types of authentication
Getting Started with API's in Power Query • My Online Training Hub
Connecting to an OAuth API Like PayPal With Power Query • My Online Training Hub
Regards
Phil
Thanks Phil. I am using Report Server. Once I build the dashboards connecting to data via APIs. Do you know if we have any limitations for scheduling auto refresh for these authentication?
I mean is automatic refresh possible in report server for data comes through API when we use
Anonymous, Basic, Web API, OAuth authentications?
PhilipTreacy Kindly help...
Hi Anonymous
OAuth authentication isn't supported for refresh in Report Server
Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs
But your Basic auth API connection should be fine.
regards
Phil