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. Troubleshooting Data Refresh Performance Issues With OData Data Sources In Power BI And Excel Using Fiddler
  2. Data Privacy Settings And Data Refresh Performance In Excel And Power BI
  3. Comparing The Performance Of CSV And Excel Data Sources In Power Query
  4. Power BI, Caching, Parallelism And Power Query Refresh Performance
  5. How To Tell Whether Query Folding Is Taking Place When Importing Data From Analysis Services In Power BI And Excel Power Query

Related Articles.