Governance Report is not loading says payload size limit is exceeding the limits.

[sharmilamusunuru]

🐛 Problem

TODO: Governance report is not loading - With payload size limits exceeding the limits. Currently using V0.11 version of Finops hub. MCA customer with billing account admin privileges is trying to pull out data in the governance report, below is the error reported.

👣 Repro steps

TODO: Add repro steps below:

1. Go to Governance.Pbit
2. Click on Load
3. See error

🤔 Expected

TODO: All the ADF pipelines are successful and remaining cost summary, workload optimization reports are loading ok., where-as governance report is not at all loading at this moment.

📷 Screenshots

TODO: Attached is the screenshot.

ℹ️ Additional context

TODO: Governance Reports fails to load in the customer environment due to payload size limits issue.

🙋‍♀️ 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.

[revaido]

Same with 0.12 - glad it's not just us with too many NSG rules, ours was returning around 22MB :)

[francesco1119]

Yeah, same here:

This bug is still open and giving problems.

[flanakin]

Sharing a comment from a related discussion for those who end up heer:

This happens because of the number of resources you have. The issue only surfaces in the Governance and sometimes Workload optimization reports because those are the only ones that query Azure Resource Graph. The fix is to simplify the query. I never dug into this query enough to understand the full details, but I believe there are some property/array expansions that bloat the row size.

As a short-term fix, I would recommend removing any columns you don't need from the query. I don't have enough context in this space to do it, but if you know what could possibly be trimmed, we can definitely take a look and easily filter things out.