Forum Discussion
fenixen
Advocate II
Advocate IICan I connect to a Amazon S3 bucket using Power Query?
Hi Amazon stores billing data in S3 buckets, i want to retrieve the CSV files and consolidate them. Is PowerBI/Power Query able to connect to S3 buckets? Regards Remi
Hi,
I used a python script in Power BI. See my suggestion at:
https://stackoverflow.com/questions/51801521/connecting-power-bi-to-s3-bucket/63185488#63185488
Hope it helps.
DB Waller
Hello! I applied a similar solution to our process extracting data from a MP Tool, but to autorefresh a dashboard you need to set up a On-premise app and this lives in your local computer, hence if it is not on it will not refresh because the script is there