Skip to content

[PowerBI] Rate Optimization Report: Error: The column 'CostWithNoReservedInstances' of the table wasn't found #1530

Description

@ahpandit

I am trying to connect the Rate Optimization PowerBI Report (for Storage Account) however, I get an error: Error: The column 'CostWithNoReservedInstances' of the table wasn't found for the Reservation Recommendations Table.

I confirmed that the data set export has the first column: "Cost With No ReservedInstances". The query in ftk_Storage, identifies this appropriately (though TotaCostWithReservedInstances seems to be incorrect and this could be another potential error

Image
Image
Image

):

else if data = "reservationrecommendations" then
#table(
{ "CostWithNoReservedInstances", "FirstUsageDate", "InstanceFlexibilityGroup", "InstanceFlexibilityRatio", "Location", "LookBackPeriod", "MeterId", "NetSavings", "NormalizedSize", "RecommendedQuantity", "RecommendedQuantityNormlized", "ResourceType", "SKU", "Scope", "SkuProperties", "Term", "TotaCostWithReservedInstances" },
{} // {{ null, null, null, null, null, null, null, null, null, null, null, _dataNotFound(), null, null, null, null }}
)

Metadata

Metadata

Assignees

Labels

Type

No fields configured for Bug.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions