Posted inData & Analysis

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

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. Data Privacy Settings And Data Refresh Performance In Excel And Power BI
  2. Troubleshooting Data Refresh Performance Issues With OData Data Sources In Power BI And Excel Using Fiddler
  3. Comparing The Performance Of CSV And Excel Data Sources In Power Query
  4. Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge
  5. Power BI, Caching, Parallelism And Power Query Refresh Performance
Tags: