Forum Discussion
Merge Queries vs Relationship
I am learning more about Merge Queries capabilities and I am not understanding when to merge vs to keep two seperate tables and build a relationship. Any good explanation?
PBInonpro , In Power BI we prefer Star schema, so we will merge the tables to create that.
In case there is information needed time and again to do row-level calculations by the second table, then we will merge to avoid cross-table operation
Can you explain this more, I am confused between merging and relationship building.