Connect PowerBI Desktop to S3

[catcollector]

Hi, we have buckets created in AWS S3. We would like to consume the data using PowerBI. I will document the steps we have tried:

1. Open desktop > Get Data > Web > under Basic tab, I put the url of the bucket (https://bucketname.s3.us-east-2.amazonaws.com/) > OK
2. On the Access Web content page, I selected 'Basic' tab
3. For the username, I believe I need to add S3 API's key as the username.

Step 3 is where I'm stuck. I have a set of keys provided to me, but we're very new to AWS. I'm not sure whether the keys are correct. Does anyone where I can get the S3 API key? Also, Thank you.

[v-shex-msft]

Hi @catcollector,

I think you need to web connector with AWS S3 REST api instead of direct get data from its homepage URL:

Amazon S3 API Reference 

Connecting REST API with OAUTh authentication 

Regards,

Xiaoxin Sheng

[catcollector]

Hi @v-shex-msft, this is my first time using both AWS and Power Bi Desktop. Please bare with me as my questions will be fairly basic.

• When you say to use web connector with AWS S3 REST api, do you mean to navigate to desktop > Get Data > Web? Once there, I get the "From Web" screen with a basic and advance option. What should I do here?
• How exactly do I call the S3 API from PowerBI?

Thank you very much.

[v-shex-msft · Accepted solution]

Hi @catcollector,

#1. Yes, you can use get data web connector with your rest API URL. BTW, normal they can't direct achieve on the navigation panel, you need to do some advanced operations in the query editor side. (optional parameters: header, authorization token, query...) @ImkeF Can you please share some suggestions or tutorials about using web connector with rest API?

#2. If you not familiar with web connector, you can take a look at the following blog about power bi to get data from AWS s3:

Read Amazon S3 data in Power BI or Call AWS REST API (JSON / XML) 

Regards,

Xiaoxin Sheng

[ImkeF]

Hi @catcollector 

Unfortunatly, this isn't easy. If possible at all, you'd have to create a custom connector for it: https://github.com/microsoft/DataConnectors 

Might better go with one of the 3rd party offers that @v-shex-msft  has linked to.

[Greg_Deckler]

https://s3browser.com/aws-access-key-id-and-secret-access-key.aspx