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 full guide here

🔍 Query AWS API Data Without Writing Code

Here's a sample query to preview patch data from AWS SSM:

SELECT * FROM "$"

WITH(

Src='cmd:>aws ssm describe-available-patches --no-verify-ssl',

"Filter"='$.Patches[*]'

)

You can apply similar logic to retrieve EC2 instance data, CloudWatch metrics, or anything else supported by AWS CLI.

Want to load this data into Power BI or Excel? We've got the exact steps for that too.

👉 Continue to the full tutorial with screenshots and query examples

🎥 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.

 👉 Watch the video and get started

✅ Conclusion

The ZappySys JSON Driver makes it incredibly easy to query AWS REST APIs from any app that supports ODBC. From Power BI dashboards to Excel spreadsheets - your data is just one query away.

💡 For more examples, advanced filter logic, and update support - 

 👉 Read the complete article here

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