Main view hits 500k KQL limit for a 30 day period, thus not showing data anymore

🐛 Problem

When viewing a month in FinOps hub, I get the error message:

"Underlying Error: QueryUserError
More details: Expression.Error: Query execution has exceeded the allowed limits (80DA0003): The results of this query exceed the set limit of 500000 records, so not all records were returned (E_QUERY_RESULT_SET_TOO_LARGE, 0x80DA0003). See https://aka.ms/kustoquerylimits for more information and possible solutions..
[0]Kusto.Data.Exceptions.KustoServicePartialQueryFailureLimitsExceededException: Query execution has exceeded the allowed limits (80DA0003): The results of this query exceed the set limit of 500000 records, so not all records were returned (E_QUERY_RESULT_SET_TOO_LARGE, 0x80DA0003). See https://aka.ms/kustoquerylimits for more information and possible solutions.."

👣 Repro steps

1. Go to Resources
2. Select time period for 30 days
3. See error: both visuals are shown as error

🤔 Expected

To see the chart and entries with their costs

📷 Screenshots

🔧 Environment

• FinOps hub version: (e.g., 0.10, 0.11, 12.0, 13.0)
• Billing account type: EA (Enterprise Agreement)
• Power BI report type: ADX (Azure Data Explorer)
• Cost Management export: FOCUS 1.0 r2

ℹ️ Additional context

It worked in the past, but since this month it looks like to be too much data

🙋‍♀️ Ask for the community

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

Reproduce the failure in the Resources view using the ADX Power BI report, FOCUS 1.0 r2 export, and a 30-day period. Start by tracing the KQL query behind the two failing visuals and identify why the result exceeds 500,000 records. Done means the chart and cost entries render for the reported scenario without the query-limit error.