Read Below:
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.
Step 1:
Login into your AWS Console as a root user (to create an S3 resource)
Step 2:
After logging into your AWS console:
Create an S3 resource and upload some data into it (preferably xlsx, csv, json files)
Step 3:
Add data to this bucket.
Step 4:
- 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.
Step 5:
In Power BI Desktop, use the Python script option under Get Data:
Step 6:
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.
Considerations:
- Please note that you must correctly set up Python Scripting settings and home directories under Global Options for this to work properly.
Akshay
DATA ANALYST
ADDEND ANALYTICS
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 kamal.sharma@addendanalytics.com or Contact us.
