Here we are going to look into how to connect Power BI with Amazon’s Simple Storage Service (S3) to get data.
You would need the following environment already set up / If not please follow the below steps.
Login into your AWS Console as a root user (to create an S3 resource)
After logging into your AWS console:
Create an S3 resource and upload some data into it (preferably xlsx, csv, json files)
Add data to this bucket.
- Create an IAM user.
- Provision (attach) AmazonS3FullUserAcces to this user as below:
- Once the user has been created, create access keys (under security credentials for this user, within Amazon IAM service as shown below):
Retrieve the access keys.
In Power BI Desktop, use the Python script option under Get Data:
Use the following code in it to get your Amazon S3 bucket data:
After following the above steps, you’ll get the data present in the S3 bucket as below:
(Never provision services within the root user account for usage purposes, always create another user and use that user account for resource consumption.) – AWS best practices.
- Please note that you must correctly set up Python Scripting settings and home directories under Global Options for this to work properly.
Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at email@example.com or Contact us.