Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
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
Proud to be a Super User!
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?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.