🐛 Problem

Comparing reservation recommendations in Advisor and in the Rate Optimization Power BI Report: Reservation Recommendation tab, the Power BI provides far fewer recommendations.

I queried the Data Explorer database and the cause seems to be a handful reservation recommendations with a future x_RecommendationDate.

👣 Repro steps

TODO: Add repro steps below:

1. Query ADX database with the following query (taken from the query used in the RateOptimization PowerBI to retrieve ReservationRecommendations):
   Recommendations_final_v1_0
   | where x_SourceProvider == 'Microsoft' and x_SourceType == 'ReservationRecommendations'
   | distinct x_RecommendationDate | order by x_RecommendationDate desc | limit 1

📷 Screenshots

Screenshot below taken on 3/11/2025.

🤔 Expected

Most recent reservation should be returned.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.