Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Amar-Agnihotri
Resolver I
Resolver I

Create AWS Cost and Usage Report in Power BI

Hi,

We are using aws and currently using aws cost Explorer to see the different console reports for aws cost usuage . Now, i have to build Cost and Usuage report in power bi. I have collected data but that is gigantic (almost 4M rows for only Sep 2022), also number of columns are almost 260. That is a single consolidated file opf all data and i have to create different tables from that . I found this aws documentation 

https://docs.aws.amazon.com/cur/latest/userguide/cost-categories-columns.html

 

but i didn't find any link that could explain the relationship between the tables. . Is there anyone who has tried to built such kind of report in power bi desktop.  I don't want to go with quicksight, that's why i want it to be done in power bi desktop. 

 

3 REPLIES 3
BrianRegan
New Member

Hello, yes, the AWS cost and usage report is massive and can be very complex.

If you're looking for details on the fields that are important for your analysis, check out this blog post from Strake (AWS cost management) that takes the total number of fields from >200 down to ~30.
Link: https://getstrake.com/blog/aws-cost-and-usage-report-documentation

ChayDommeti
Frequent Visitor

were you succesful in implementing your plan? we also are multi cloud and we pull all cost data into Power BI, Trying to get AWS cost data as well into Power BI. Let me know if you did it 

v-stephen-msft
Community Support
Community Support

Hi @Amar-Agnihotri ,

 

Please kindly refer to the official document:

Set up AWS integration with Cost Management - Microsoft Cost Management | Microsoft Learn

Or maybe try the ODBC connector:

How to Connect to an ODBC Data Source From Power B... - Microsoft Power BI Community

powerbi - Credentials for AWS Athena ODBC connection - Stack Overflow

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors