Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |