Forum Discussion
Slow performance
Hello camargos88,
The disconnected dataset works perfectly fine, but when I create a relationship between the datasets that's when the issue starts, the relationship is one-to-many, I've been testing other relationships to see if there are any changes, but one-to-many is the only relationship permitted between these datasets.
And other alternative testings on canvas too like testing the data on a table or matrix, tables are performing a bit faster than the matrix, things like that.
Anonymous ,
So it's necessary to check the generated query pushed to the database and try to execute it directly on the source to see how fast it returns.
How many rows are we talking about ?
The usual thing while creating my reports is that I always work on the queries on MS studio test them and then bring them into Power BI, output on MS studio is within 3-4 secs, with 3402 rows to be exact (this is on my testing lab).
On Power Query the query loads fine and I make sure everything is good, then I do a close and apply.
Anonymous ,
It's possible that PQ is folding the query with the user interactions... so it's pushing a new query (with the applied filters) to the source.
Can you check from the database side the execution time for those visuals with problems ?