Hi,
I have a query that gives me the below but the query in the database runs in under 7 seconds, it has only 22341 rows and is 22.3MBs. If I put in in SPICE it runs very quick but why so slow in direct query with such a small query?
Hello @pantelis
I’m going to assume this happening in direct query. Are you using a calculated field or filters in the visual?
Hello @pantelis
Are you still running into this issue or were you able to find a solution?
Yes I am using calculated fields
Hey @pantelis
It can depend on a lot of different variables but if you are using a complex calculation with filters/parameters in something like a pivot table you might run into an error like this. I would recommend troubleshooting ways to simplify the query.
I would recommend avoiding direct query as well unless there is a specific need like near real time data. This blog is older but still helpful as well:
Hi @duncan
I have the same problem in another analysis.
The query behind the dataset runs in 7 seconds with just 75k rows.
The visual doesn’t even have a calculated field. How can the visual be so slow to respond?
