Forum Discussion
Slow performance
Hi,
I have created a Power BI report and have noticed something odd with my reports, Let me explain a little about this report, I've created a report with four datasets and connected these datasets, when I create visuals they take roughly around 30-40 secs to display results on the visuals. Later I identified a single view which had the exact same columns needed for these reports and switched the query and merged three datasets into a single dataset and connected the datasets, now I had just two datasets, with this I hoped that the reports would be faster in displaying results but on the contrary, these visuals now take over 7-8 mins to run, it's insanely slow and I don't understand the reason what's causing this to happen.
Also, I do not have any calculated columns or measures, the datasets are in Direct Query mode and hence no transformations on any of them, the datasets are connected as one-to-many with a single filter. There are many other reports that I have built over the months the exact same way and never have I ever seen any sought of performance issues on those reports. I use the exact same query on SSRS and the report works perfectly fine.
I would really appreciate it if there are any suggestions/tips/solutions for this issue. Would also like to know if any have faced similar issues before.
7 Replies
- camargos88Community Champion
Anonymous ,
It would be nice to check the transformations that you have done on Power Query and the how query is executing on the source.
- AnonymousNot applicable
Hello camargos88,
All datasets are in Direct Query mode, so non of the datasets have any transformations on it. Still trying to figure what's causing the reports to run slow.
- camargos88Community Champion
Anonymous ,
Maybe the generated query is not performing well on the source.
If you work with a disconnected table, you get the same performance ?