Forum Discussion
Solved
Visual Times out
Hello My visual times allways out. Is there a possiblity to get the result. The data is direct query (no possibility to change that). I am filtering as much as possible but no success. Is there a...
Hi Heinrich ,
Whats is the connector you are using? Are you using the CQD connector?
How the link below they talk about some of the question about the connectivity to CDQ specially the question about the filtering of data.
https://learn.microsoft.com/en-us/microsoftteams/cqd-power-bi-connector
Hello
Hope you are all doing well.
I have these configurations or details
- No query limits
- Time out is on Power BI Desktop
- The type of visualization is "table" pulling 3 columns of a direct query database (not possible to switch to import mode)
- No additional message in the error
- The row number would be at least ~200k
- I tried to filter as much as possible but no luck
Thanks for your support
Regards
Heinrich
Hi Royel ,
Are you doing DQ based on tables of the database or a SQL query?
Based on your description the time out is coming from the datasource, don't know what is the database you are using but did you setup the timeout options to be larger? You can be hitting the maximum of timeout in your database and then it's returning that error.
