Skip to main content

Power BI

New

Is there a way to access AWS S3 file from Power BI?

Vote (9) Share
Dipankar Pal's profile image

Dipankar Pal on 23 Nov 2016 16:17:56

I have data files available in AWS S3 and I need to read and join them to generate reports in Power BI. Is there a direct or indirect way to read data from AWS S3?

Comments (2)
Dipankar Pal's profile image Profile Picture

879170cf 37b0-4ed5-8d61-1f127f0fe7b2 on 05 Jul 2020 23:22:42

RE: Is there a way to access AWS S3 file from Power BI?

ZappySys has ODBC Driver for XML/JSON API which can be used to pull data directly from AWS S3 or other AWS API (e.g. Athena, EC2, Billing API). See below Post

https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/

Dipankar Pal's profile image Profile Picture

8ffae80a 13e4-406e-b63f-94fed9d0239e on 05 Jul 2020 22:36:56

RE: Is there a way to access AWS S3 file from Power BI?

This is already an open request: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7689123-allow-connection-to-aws-s3

Please vote!