Improving The Performance Of Aggregation After A Merge In Power BI And Excel Power Query/Get&Transform

By admin in Data & Analysis

A long time ago someone – probably from the Power Query dev team – told me that adding primary keys to M tables could improve the performance of certain transformations in Power BI and Excel Power Query/Get&Transform.

Bron : Chris Webb’s BI Blog
Lees meer…

Gerelateerde artikelen:

  1. Removing Punctuation From Text With The Text.Select M Function In Power BI/Power Query/Excel Get&Transform
  2. Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications
  3. “In the Previous” Date Filters In Power BI/Get&Transform/Power Query
  4. Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform
  5. Data Privacy Settings In Power BI/Power Query, Part 2: Preventing Query Execution

Related Articles.