Error Message: Input query length exceeding the supported maximum length

Hi cn4422 ,

Based on your description, your data source is probably connecting in import mode. You mentioned that these visualizations were working fine before, but recently there have been errors. This may be due to the fact that queries in published reports will be limited by the query runtime, as well as the amount of memory the query can use. These limits may change depending on where the data is hosted. This is to prevent any individual query from consuming too many resources.

You can set the limits on the amount of memory that can be used by a query in the
Select File > Options and Settings > Options
Under Current File, select Report Settings.
Scroll to the Query Limit Simulation section.

If you choose to apply custom limits, enter specific timeout and memory limits in the input fields. When setting your own limits, you can use “0” for “no limit”.

After the setup is complete, you can re-upload the report to check.

Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn

How to Use Query Limit Simulations to Optimise Your Power BI Reports | by Masego | Medium

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly