Forum Discussion
Visual Times out
- 10 months ago
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.
- Royel10 months agoSuper User
Hi MFelix seems like this question is for Heinrich right?
I tried to understand the problem and find a wayout with Power BI Desktop.
- MFelix10 months agoSuper User
Yes you are correct.
Sometimes selecting the users it picks up the last One that answered the post .
- Heinrich10 months agoPost Partisan
Hello MFelix
Hello Royel
Thanks
I am Direct Querying against Microsoft using CQD as Data Source for our Teams Analysis.
The problem is I can not change settings on the database. The only thing is to adapt the Power BI Query. Do you see the possibility to change some settings?
Regards
Heinrich