Forum Discussion
Difference between Model and Power Query Relationship (Better Way)
kolturra ,
If you don't need to keep two different tables, I would suggest you to merge or append tables in power query. Because if you just make relationship between two tables in your report, when you create some measure or calculate columns, dax function will do table scanning in another table. This will slow down your report performance.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi kolturra
Ideally you want to do most of your transformation in Qury Editor, this should reduce the size of your Model and at times improve the performance.
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks very much for your reply.
So you meant to say Power Query Editor give best performance while doing relationship.
Thanks,
K Raghavender Rao
kolturra ,
If you don't need to keep two different tables, I would suggest you to merge or append tables in power query. Because if you just make relationship between two tables in your report, when you create some measure or calculate columns, dax function will do table scanning in another table. This will slow down your report performance.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
