Skip to content

[Power BI] Remove deprecated features in storage reports #1380

@flanakin

Description

@flanakin

⚠️ Problem

Power BI storage reports are very slow due to all the processing requires to align different versions of FOCUS and minor bug fixes that have been applied, which should no longer be needed. This includes:

  • Support for FOCUS 1.0-preview.
  • Tracking data quality issues with the x_SourceChanges column.
  • Fixing x_SkuTerm values to be numbers for MCA.
  • Informative x_FreeReason column to explain why a row might have no cost.
  • Unique name columns to help distinguish between multiple objects with the same display name.

🛠️ Solution

  • Only run extra steps when a Deprecated: Perform Extra Query Optimizations parameter is enabled for storage reports
  • In 0.9, disable the PEQO parameter in storage reports
  • On or after July 2025, remove the PEQO parameter and corresponding steps
  • Consider adding a parameter for supporting historical FOCUS versions
  • Document which versions of FOCUS are supported by which FTK versions
  • Document that older FOCUS version are supported by FinOps hubs with Data Explorer

🙋‍♀️ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Please vote this issue up with a 🚀 if you need support for older FOCUS versions.
  3. Leave comments to help us solidify the vision.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions