[Power BI][Rate Optimization] Unable to populate visuals for Recommendations (subscription) tab

[MS-mikeo]

🐛 Problem

This is in relation to the issue opened for https://github.com/microsoft/finops-toolkit/issues/702. The same customer has setup the new Rate Optimization report to work with the Cost Management connector with no errors now, so that piece is fixed in the new report. All of the data is in the tables for RecommendationsSingle and RecommendationsShared with the time set for 1 month as the default. We had to play with the filters to get the data showing in the Recommendations (shared) tab & got that working. The Recommendations (subscription) tab we cannot get to populate with visuals, but we have confirmed that the data is in the table.

👣 Repro steps

1. Configure the cost management connector for the Rate Optimization report
2. Verify data is in both RecommendationsSingle and RecommendationsShared tables
3. Check the report tabs for Recommendations (shared) and Recommendations (subscription)

🤔 Expected

Views populating in the report tabs for Recommendations (shared) and Recommendations (subscription)

📷 Screenshots

Working for Recommendations (shared):

Not working for Recommendations (subscription):

🙋‍♀️ Ask for the community

1. Please vote this issue up (👍) to prioritize it.

[arthurclares]

Dhanyal Shahid reported the same issue offline.

[flanakin]

Strange... I'm not sure what would cause this off the top of my head. I'd probably need to look at the PBIX file with data to troubleshoot. Feel free to setup some time with me to debug, if you have the file.

As a side note, we have an open PR to replace the connector with exports, so there will be a change in the next release that might resolve this.

[MS-mikeo]

This can probably wait until the next release. I will have them test again once the connector is replaced.