Forum Discussion
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 HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous thanks for your reply - I will definitely check that out and see if it can fix the issue.
I've also found out, that one thing that changed, was that a field I've already used in the previous report has now a lot more characaters in it, up to a few hundred... could this also be an issue with this error message?
Hi cn4422 ,
Your reference to hundreds of characters is probably not the reason for this question, as the “text” data type is a Unicode character data string, and the actual maximum string length is limited to about 32,000 Unicode characters.
You can do a distribution query to determine where the error occurs
Data types in Power BI Desktop - Power BI | Microsoft Learn
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