Create AWS Cost and Usage Report in Power BI

[Amar-Agnihotri]

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. 

[BrianRegan]

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]

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 

[Anonymous]

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.