I have a database in Analysis Services Tabular and a table with direct query.
When I’m creating a table (without relationships and nothing stranger) and after I do a simple query against that table then it take a loooong time
For example, after creating the table I simply query it with “evaluate” and it takes many seconds.
How can I avoid that initial delay?
In the followings executions of my query it takes only 1 second
EVALUATE MyTable
I’ve try processing my table.
It seems that Analysis Services does not know the metadata of the table and needs to build it beforehand (like a full processing)
Even though it has already created the table few seconds ago
If I do the comparison with SQL Server, there I create the table, then query it and it doesn’t take long.