Difference between Model and Power Query Relationship (Better Way)

[kolturra]

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

[Mariusz]

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.

[v-yuta-msft · Accepted solution]

@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.

[kolturra]

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