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
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...
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!
Thanks for your input!
I'll definitely try to connect each source under their own Windsor.ai connector and see if this improves things!