Forum Discussion
Power BI : Connecting to AWS S3 Billing REST APIs
Hi, I need to develop AWS billing dashboard for which our team stores data in CSV files in AWS S3 bucket. After some research on Power BI Community, I understand there are two ways to connect.
1. Through zappysys S3 csv driver : Since its a licensed utility, I can't go with it
2. By connecting AWS S3 billing REST APIs via Web Connector and parse JSON response
I went through many articles which are listed below but didn't found any practical information where demonstration of Power BI connecting to S3 buckets via Web connector is done. Can someone please post a step by step tutorial here which can be used in the future for everyone.
References I have gone through :
https://community.powerbi.com/t5/Power-Query/Can-I-connect-to-a-Amazon-S3-bucket-using-Power-Query/td-p/111919
https://community.powerbi.com/t5/Service/Power-BI-Web-App-and-AWS-S3/td-p/617949#:~:text=It%20is%20not%20possible%20to,in%20Power%20BI%20web%20connector.
https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006
Please help. Greg_Deckler amitchandak
7 Replies
- v-eachen-msftCommunity Support
Hi Anonymous ,
Here are some useful links for your reference.
https://www.stitchdata.com/integrations/s3-csv/powerbi/
https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/
- AnonymousNot applicable
Hi v-eachen-msft I appreciate your answers but I am looking to connect to S3 directly from Power BI without any ETL programming and since Zappysys is paid service so that is not an option for me.
- mjkilpatRegular Visitor
hi greg. did you ever get this working? thx
- adeelazizFrequent Visitor
Has anyone figured out how to bring AWS costs into PowerBi?
- ChayDommetiFrequent Visitor
I am also looking for the same, Have you figured out any solution?
- skypurplecloudNew Member
Hi There.
Did you ever resolve this issue? Did you look at possibly automating a copy of the CUR zip files or .csv files from the S3 bucket across to a location in Azure where you can access them for PowerBI?
Wonder what people think of that option?
Roy.
- mjkilpatRegular Visitor
PowerBI released a new Athena connector a few months ago... we are working on this solution to view CUR data.