Forum Discussion
Can I connect to a Amazon S3 bucket using Power Query?
Hi fenixen,
As the Amazon S3 is a web service and supports the REST API. You can try to use web data source to get data. See:
Amazon S3 REST API Introduction
How to call REST APIs and parse JSON with Power BI
Another I can think of is importing data from Amazon S3 into Amazon Redshift. then in Power BI desktop, use Amazon Redshift connector get data. See: Loading Data from Amazon S3.
Best Regards,
Qiuyun YuHi,
ZappySys has released API drivers (XML and JSON) with AWS API support. See below blog post it explains scenario of how to access AWS S3 data in Power BI. It also explains Billing / Cost API usecase via API calls. ZappySys will rease CSV driver very soon which will support your scenario of reading CSV from S3 in Power BI but until that you can call Billing API (JSON format)
https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/
Query Amazon Billing APIConfigure AWS Connection using ZappySys ODBC Driver (XML or JSON)Import Amazon Billing data in Power BI using ZappySys Driver
Hi fenixen , could you solve your problem? I´m facing the same situation now. I´m able to get url, credentials and s3path with Power Query (Power BI) but not sure how to use them to get the csv file with the data that I need.
Hi gdecome
I landed on a semi-manual solution using https://s3browser.com/ to retrieve the data files and then connecting to the files using Power Query. I didn't have people available to help me with API.