How to Read AWS REST API Data in Power BI, Excel, and More - Without Coding

If you need to access AWS REST API data in tools like Power BI, Excel, Informatica, or MS Access but don't want to dive into coding, this guide is for you.

We'll show you how to use the ZappySys ODBC JSON Driver to capture AWS CLI output and feed it into your ODBC-enabled apps - quickly and easily.

✅ Bonus: If you prefer a low-level method without AWS CLI, we've covered that too in the full version of this guide.

Requirements

Before you begin, make sure you have:

✔️ Installed the AWS CLI

✔️ Downloaded ZappySys ODBC PowerPack

[✔️ Set up a new ODBC DSN with ZappySys JSON Driver]

Step-by-Step Setup

1. Open the ODBC Data Source Admin
   Open the Start menu, search for "ODBC", and launch ODBC Data Source (64-bit).


2. Add a New DSN
   In the System DSN tab:
   Click Add
   Select ZappySys JSON Driver
   Click Finish

🎯 Need screenshots and DSN examples? View the

🎥 Bonus: Video Tutorial

Prefer watching over reading?

🎬 Check out our video: How to read and write AWS REST API data using the ZappySys ODBC Driver.

 👉

Need help? Our support team is always here for you via chat on our website.