Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Hope everyone is doing.
Regarding relationship i have doubt. i need to understand which run faster when we do the relationships at Power Query level or Model level.
In Power Query we use Merger or Append Queries
In Model we use direct relationship
Thanks,
K Raghavender Rao
Solved! Go to Solution.
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.
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,
Thanks very much for your reply.
So you meant to say Power Query Editor give best performance while doing relationship.
Thanks,
K Raghavender Rao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |