Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
I am completely new to AWS. Just wanted to know how we can bring the Cost from the AWS server to power BI desktop.
we have cost data such as EC2, S3,RDBMS, Search and etc in Power BI. we are currently pulling the data from AWS manually and update it to CSV file to get into power BI. is there a way we can connect directly to AWS to get these cost details in Power BI?
Please help.
Hello @MAwwad , I don't see Amazon Web Services not even in the Appendix: Microsoft Power BI supported AWS data sources you provided.
So do I have to create a connector for AWS?
es, it is possible to connect Power BI directly to your AWS account to retrieve cost data. Here's one way you can do it:
In Power BI Desktop, select "Get Data" from the Home ribbon and then select "Amazon Web Services" as the data source.
In the "Connect to Amazon Web Services" dialog, enter your AWS access key and secret key, and then click "Connect".
In the "Amazon Web Services" dialog, select the "Cost and Usage" option from the list of available datasets.
Click "Load" to load the cost data into Power BI.
In the Query Editor, you can use the "Transform" tab of the ribbon to shape and manipulate the data as needed.
When you are finished, click "Close & Apply" in the Query Editor to load the data into the Power BI data model.
This will allow you to connect directly to your AWS account and retrieve cost data in real-time, without the need to manually update a CSV file.
There is no "Connect to Amazon Web Services" dialog in Power BI
Has anyone figured this out. I'm not seeing "Amazon Web Services" as a data source
there is no AWS web services in the Get data
It makes no sense @MAwwad .
I read that appendix and the supported connector are:
So no, there is no way to connect Power BI to the Amazon Cost Usage
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |