I am using FinOps Hub 0.2 Rc2 (v0.2 would give me the error we cannot convert the value null to type Table.) and the Power Bi report CommitmentDiscounts.pbix
When i fetch data i get this error
The problem are related to the x_SkuTerm column
The source file contain the value 3years as string, but the report expects an Integer, I am not very good at Power Bi, but i have replaced the faulty value and tried to load the fixed query into the report, along with the other CostDetails query, it look OK
However, it doesn't seem to work
I can see the data in the table view.
Maybe this is beacuse my "fix" isn't working.
Could the issue with the incorrect value type be fixed with some conditional statement, translating "3years" to 36 when loading the data?
Maybe 1year needs to be handled as well.
I am using FinOps Hub 0.2 Rc2 (v0.2 would give me the error
we cannot convert the value null to type Table.) and the Power Bi report CommitmentDiscounts.pbixWhen i fetch data i get this error
The problem are related to the x_SkuTerm column
The source file contain the value 3years as
string, but the report expects anInteger, I am not very good at Power Bi, but i have replaced the faulty value and tried to load the fixed query into the report, along with the other CostDetails query, it look OKHowever, it doesn't seem to work
I can see the data in the table view.
Maybe this is beacuse my "fix" isn't working.
Could the issue with the incorrect value type be fixed with some conditional statement, translating "3years" to 36 when loading the data?
Maybe 1year needs to be handled as well.