Help enabling Recommendation feature on FinOps Hub v14

[fajterini]

Hi I am doing PoC for FinOps hub.

I have deployed FinOps Hub with ADX and everything is working. We use manual data import for now.

I wanted to enable Recommendation -> https://learn.microsoft.com/en-us/cloud-computing/finops/toolkit/hubs/configure-recommendations

I modified our bicep parameter file and added

param enableRecommendations = true

Solution was redeployed and looks like Azure deployment was ok ..

But noticed that Pipeline in Data factory is failing:

queries_ExecuteETL with error:

ErrorCode=UserErrorFileNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'NotFound'. Account: 'finopsXXXX'. FileSystem: 'config'. Path: 'queries'. ErrorCode: 'PathNotFound'. Message: 'The specified path does not exist.'.

I checked stroage account and queries folder is not there:

But I think I am missing something.

I will test to manually upload the src/templates/finops-hub/modules/Microsoft.FinOpsHubs/Recommendations/queries

How should this be deployed, how does the recommendations work, as this is not clear from documentation ?

[fajterini]

Just update, manual copy of queries folder to storage account fixed the DF pipeline. But the solution is still not working.

• ingestion/Recommendations folder have new json file with recommendations, but Azure Data Explorer, Recommendations_raw view is empty.

[helderpinto]

@fajterini, thanks for reporting this. Something seems to have failed when redeploying. The queries folder should have been created. I am glad you were able to fix it. It's something we will look into.

Regarding the empty Recommendations_raw table, this is expected, as data is moved to a different table once ingested. Use this query to find your recommendations:

let LastRecommendationsIngestion = toscalar(database('Hub').Recommendations() | summarize max(x_IngestionTime));
database('Hub').Recommendations()
| where x_IngestionTime > LastRecommendationsIngestion-1h

[fajterini]

Hi @helderpinto thanks for reply.

I needed just more time, but the results are there and your query worked.
But I wanted to ask is there a PowerBI report that could be used to show this?

I found in documentation ->> https://learn.microsoft.com/en-us/cloud-computing/finops/toolkit/hubs/data-model#recommendations-managed-dataset

Recommendations table in Power BI reports.

But i was checking most of the KQL PowerBI reports and didn't find where this should be visible.

[helderpinto]

There aren't reports available yet. This will be provided in a future release.

[fajterini]

I take this is new feature and is still in progress. But even now the data will be useful for us.

Thanks for clarification.