cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
catcollector
Helper I
Helper I

Connect PowerBI Desktop to S3

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.

1 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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

5 REPLIES 5
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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.

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

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.

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Greg_Deckler
Super User
Super User

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

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!