Error Message: Input query length exceeding the supported maximum length

[cn4422]

Hello,

in several of my reports I'm facing the issue of "input query length exceeding the supported maximum length".

My data is coming from several sources, including dataverse (CRM), windsor.ai (google ads, facebook ads) as well as static files.

This also affects reports that have previously worked but suddenly the visuals don't load anymore and the error message keeps popping up. Like in the example on the attached screenshot.

I've tried to reduce filters and make it less complex but it somehow doesn't work.

Sometimes this also happens when I simply rename field-values in a visual - and then the visual isn't display correctly and the error message keeps popping up.

That's really frustrating and very time-consuming...

Any idea about that?

Thanks in advance! 🙂

[v-heq-msft · Accepted solution]

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

[cn4422]

@v-heq-msft  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?

[CoderZen08]

Hi @cn4422 Windsor.ai user here. Is the field you mention that has now a lot of characters in it from any specific windsor.ai connector? In case it is, maybe you can give more details so I can try helping you out

[cn4422]

@CoderZen08  Hi, thanks for your reply. Actually, in this case it's nothing to do with windsor.ai connector, it's about a field coming from the CRM.

But I would be interested in your opinion since you are a windsor.ai user... did you have any issues if you combine several sources, like dataverse with windsor.ai in terms of error messages or speed issues? Because sometimes in my reports/visuals the loading time is just a real pain... and I'm not sure what the reason for this is but I suspected that it might be all the different sources...

[CoderZen08]

You mean dataverse through native connection and Windsor.ai sources in the same Looker report? From what I've been told from support more than once is to don't have multiple slides in the same report since that can slown down performance sometimes. Also when I connect more than source I prefer connect each source under their own Windsor.ai connector in my report and if I have to blend data I do it inside of Looker Studio. I've been doing this and works fine but of course some connectors are slower than others

Hope this helps!

[cn4422]

Thanks for your input!

I'll definitely try to connect each source  under their own Windsor.ai connector and see if this improves things!

[v-heq-msft]

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