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



):
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 }}
)
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
):
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 }}
)