Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (248)
  • Dynamics NAV & BC (5,178)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (4,999)
  • ERP general (347)
  • Information management (58)
  • Off-topic (47)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

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

By admin in Data & Analysis 30 March 2018

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…

Share this:

  • Facebook
  • LinkedIn
  • WhatsApp
  • Twitter
  • Email
  • Print

Like this:

Like Loading...

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 excelMergePerformancePower BI
AL with VSCode: IntelliSense Fix
How to Save Commonly Used Filters in Dynamics NAV

Related Articles.

High Performance Posting to the G/L

04 Aug, 2022

Resolve Merge Conflicts using “Pull Request Merge Conflicts” Microsoft DevOps Extension

02 Aug, 2022

Performance Articles For Developers

12 May, 2022

Excel Reports – something new in reporting space

12 May, 2022

Dynamics 365 Business Central: How to disable “Edit in Excel” on a specific page

10 May, 2022
Pardaan.com

Microsoft Dynamics NAV, Business Central, ERP general, Projectmanagement, Information management and Visual C#


Dennis Pardaan

Facebook page

Facebook page

Stay Hungry, Stay Foolish

RSS Mibuso

  • GuiAllowed - stop pop up message for dimensions when creating Job from AL
  • Replication from HO to a store
  • Creating empty container (CSIDE)
  • HideDialog When background process create pick list
  • convert pdf file to base64 string
  • Can I create a receipt/ticket printer report like in shops/supermarkets?
  • Business Central version 15 (On-premise) - Long Running Queries
  • User-defined views crashes client.
  • Deployment of app file to Dynamics BC OnPrem
  • Adding parameter to Report 292 Copy Sales Document
  • Parameters in the cloud
  • NAV 2017- Positive Pay Modifications
  • US Sales Tax
  • Database locks across instances (NAV 2017)
  • Dynamics NAV 2013 Generating a GS1 2D Matrix Barcode
  • POS Hardware Profile
  • POS Hardware Issue
  • HTTPWebRequest error handling vs PS Invoke-WebRequest
  • Modify other line in form
  • POS Hardware Issue

RSS Dynamics NAV Team Blog

  • Exchange Online Basic authentication is going away: What you need to know
  • Microsoft is a Leader in The Forrester Wave: CRM Suites, Q3 2022
  • The AI-powered contact center, part 1: Create engaging digital experiences
  • Supercharge your CRM with Microsoft Viva Sales—Now in preview
  • Strike a strategic inventory balance in your supply chain with demand driven material requirements planning (DDMRP)
  • Honor customer data use consent with unified profiles in Dynamics 365 Customer Insights
  • Introducing the Microsoft Digital Contact Center Platform: A comprehensive, flexible customer care solution
  • Modernize employee expense management with automation and AI
  • 2022 release wave 2 plans for Dynamics 365 and Power Platform now available 
  • How to build a modern field service organization

RSS Power BI

  • PostgreSQL connector for the virtual network data gateway
  • Power BI August 2022 Feature Summary
  • Announcing improvements to Datamart Query editor
  • Join us! 18-23 September 2022. The FIRST ever Microsoft Power Platform Conference!
  • Announcing: The Power BI app is available in Microsoft Teams Mobile
  • ADLS Gen2 and Azure Blobs SAS Key Connectivity
  • Analysis Services server properties in Power BI Premium are now in public preview
  • On-premises data gateway July 2022 update is now available
  • Power BI Ideas site improvement updates
  • Introducing a new way to purchase licensed Power BI visuals and manage licenses through Microsoft platforms
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
%d bloggers like this: