Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
Solved! Go to 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
Hi @catcollector,
I think you need to web connector with AWS S3 REST api instead of direct get data from its homepage URL:
Connecting REST API with OAUTh authentication
Regards,
Xiaoxin Sheng
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |