finops-toolkit icon indicating copy to clipboard operation
finops-toolkit copied to clipboard

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

Open MS-mikeo opened this issue 1 year ago • 5 comments

🐛 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): image

image

Not working for Recommendations (subscription): image

image

🙋‍♀️ Ask for the community

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

MS-mikeo avatar Aug 01 '24 16:08 MS-mikeo

Dhanyal Shahid reported the same issue offline.

arthurclares avatar Aug 02 '24 09:08 arthurclares

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.

flanakin avatar Aug 15 '24 02:08 flanakin

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

MS-mikeo avatar Aug 15 '24 12:08 MS-mikeo

@MS-mikeo Is this still an issue? We've made a few changes since August and I'm not sure how to replicate this to confirm it's still occurring or not 😕

flanakin avatar Mar 09 '25 07:03 flanakin

I will reach out and try to confirm if this is still an issue or not.

MS-mikeo avatar Mar 10 '25 13:03 MS-mikeo