Why is it so complex to connect to an API with Power BI or Power Query? The OAuth explained
It’s easier to explain using analogies, so let’s go with that!
Analogy: Imagine that you have a gym subscription and this gym also has a VIP lounge, but to get to the lounge you need to head to the front-desk to get authorization for a limited time.
Using MailChimp as an example:
- The gym is actually MailChimp – they put all the facilities for you
- The lounge section is their API and its where you can “access” your data
- The front-desk authorization is what we know as a Authorization Token, which grants us the chance to “be” in the API
I’m overly simplifying things here, but the main idea is that the “vip lounge” is the place that the “gym” gives you to do what they give you access to do. They (the gym) could give you access to read, write, delete or modify “data”.
Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks.
He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP – MCSA: BI Reporting), a Microsoft Certified Trainer (MCT), and is one of the international pioneers in Power Pivot, Power Query and Power BI.