Forum Discussion
Performance tuning for DirectQuery datasets
I have prepared a report with my fact table in DirectQuery Mode. Some of the visuals take 10-20 seconds to load. The measure is not complex,it is just a count of a column. If a visual is taking 20 se...
amitchandak Thanks Amit for the response. If you have worked on DirectQuery datasets, can you please tell me a rough estimate of how much time an visual takes to load. I know it depends on the dataset. But I just want to understand that the time taken my visual is of acceptable standard or it can be improved further?
- Our table contains 7 million rows. If I do a count of a column and slice it by a row from dimension table, it takes around 15 seconds. Is it high or is this expected in DirectQuery Mode?