[PowerBI] Governance Report (KQL Version) Throws `Response Payload Limit` Error

[AErmie]

🐛 Problem

When trying to view/load the Governance.kql.pbit file locally (in PowerBI Desktop), the PolicyDefinitions query throws the following error:

OLE DB or ODBC error: [Expression.Error] Please provide below info when asking for support: timestamp = 2025-04-09T18:22:42.5624383Z, correlationId = 3f162e1f-968a-4bce-a67b-c2087200fc2b. Details: Response payload size is 31530351, and has exceeded the limit of 16777216. Please consider querying less data at a time and make paginated call if needed..

This is using the default value for Number of months (which is 13) of data to retrieve.

👣 Repro steps

TODO: Add repro steps below:

1. Deploy the FTK using the private configuration, including the ADX cluster option
2. Download the latest version (v0.9) of the PowerBI reports
3. Open the Governance.kql.pbit file locally, using the default "Number of months", and "Default granularity"
4. See error

🤔 Expected

The report should load without error. If there is a limit/issue with the amount of data queried, additional parameters should be provided to customize this.

📷 Screenshots

ℹ️ Additional context

A similar, but slightly different, error is thrown in PowerBI.com (which is configured to use the Virtual Network Data Gateway).

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Please provide below info when asking for support: timestamp = 2025-04-09T00:08:16.0674468Z, correlationId = 02058071-4432-4405-af24-946a61d3b79d. Details: Response payload size is 31530307, and has exceeded the limit of 16777216. Please consider querying less data at a time and make paginated call if needed."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":null}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: PolicyDefinitions.

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

[flanakin]

@nteyan can you take a look at this? I think we may have another issue on this as well. We need to figure out how to handle data at scale without failing. It's okay if the answer is we can't show everything and you need to use ADX, if that's the eventual answer. But we can't have the report fail completely.