Query folding in Power Query

Sdílet
Vložit
  • čas přidán 27. 06. 2023
  • Find out what query folding is, why it's important for performance and what can stop it happening.
    Speaker: Chris Webb SQLbits.com/speakers/Chris_Webb
    Speaker Blog: blog.crossjoin.co.uk/
    Speaker BIO: Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft.
    SQLbits.com/Sessions/Query_fol...
    Tags: Azure,Power BI,Excel,Optimising,Data Visualisation & Modelling

Komentáře • 2

  • @woliveiras
    @woliveiras Před 3 měsíci

    This is the best explanation about Query Folding ever. Thank you for being so clear and concise.💯

  • @joselencinamalgor6548
    @joselencinamalgor6548 Před 7 měsíci

    Hi. Nice presentation. Are some best practices order steps list that's enable query folding in SQL? or a list of transformation who's broke de query folding like "index" . Thanks

Další v pořadí
Automatické přehrávání
Supercharge Power BI Tooltips21:04Supercharge Power BI Tooltips
Supercharge Power BI TooltipsSQLBits
zhlédnutí 641
Maximizing Database Performance With Isolation Levels46:30Maximizing Database Performance With Isolation Levels
Maximizing Database Performance With Isolation LevelsSQLBits
zhlédnutí 549
Your Performance Tuning Check List53:40Your Performance Tuning Check List
Your Performance Tuning Check ListSQLBits
zhlédnutí 316
WHY IS THIS SO FUNNY😂00:15WHY IS THIS SO FUNNY😂
WHY IS THIS SO FUNNY😂Noogi
zhlédnutí 14M
Střelec na Donalda Trumpa - Thomas Crooks | Co o něm po týdnu víme? | #mscrewpodcast01:00Střelec na Donalda Trumpa - Thomas Crooks | Co o něm po týdnu víme? | #mscrewpodcast
Střelec na Donalda Trumpa - Thomas Crooks | Co o něm po týdnu víme? | #mscrewpodcastMichal Šopor
zhlédnutí 607K
A teacher captured the cutest moment at the nursery #shorts00:33A teacher captured the cutest moment at the nursery #shorts
A teacher captured the cutest moment at the nursery #shortsFabiosa Stories
zhlédnutí 57M
Llegó al techo 😱00:37Llegó al techo 😱
Llegó al techo 😱Juan De Dios Pantoja
zhlédnutí 61M
Azure Synapse Analytics vs Databricks Differences #azure #azuresynapseanalytics #databricks3:30Azure Synapse Analytics vs Databricks Differences #azure #azuresynapseanalytics #databricks
Azure Synapse Analytics vs Databricks Differences #azure #azuresynapseanalytics #databricksLearn With Priyanka
zhlédnutí 4,6K
Streamlining Power BI with PowerShell48:11Streamlining Power BI with PowerShell
Streamlining Power BI with PowerShellSQLBits
zhlédnutí 237
Concepts: Index Fragmentation and Page Density | Microsoft SQL Server | Indexing | Data Science19:38Concepts: Index Fragmentation and Page Density | Microsoft SQL Server | Indexing | Data Science
Concepts: Index Fragmentation and Page Density | Microsoft SQL Server | Indexing | Data ScienceTechie Vineet
zhlédnutí 63
Stop, Intel’s Already Dead! - AMD Ryzen 9600X & 9700X Review13:47Stop, Intel’s Already Dead! - AMD Ryzen 9600X & 9700X Review
Stop, Intel’s Already Dead! - AMD Ryzen 9600X & 9700X ReviewLinus Tech Tips
zhlédnutí 1,2M
Let me show you why data types still matter19:08Let me show you why data types still matter
Let me show you why data types still matterSQLBits
zhlédnutí 117
How To Actually Make Decisions When Architecting a Data Platform19:25How To Actually Make Decisions When Architecting a Data Platform
How To Actually Make Decisions When Architecting a Data PlatformSQLBits
zhlédnutí 188
4.05 Mastering Real-Time Intelligence on your databases32:434.05 Mastering Real-Time Intelligence on your databases
4.05 Mastering Real-Time Intelligence on your databasesFikrat Azizov
zhlédnutí 185
The Fundamentals of DAX Contexts51:54The Fundamentals of DAX Contexts
The Fundamentals of DAX ContextsSQLBits
zhlédnutí 276
REAKCE: Tiskovka Clash of the Stars 9 je extrém!1:57:21REAKCE: Tiskovka Clash of the Stars 9 je extrém!
REAKCE: Tiskovka Clash of the Stars 9 je extrém!FattyPillowTV
zhlédnutí 122K
KARMA AT SCHOOL 🏫 Stop time00:32KARMA AT SCHOOL 🏫 Stop time
KARMA AT SCHOOL 🏫 Stop timedednahype
zhlédnutí 58M
VAŠE DÁVKA USPOKOJENÍ #74 😍00:44VAŠE DÁVKA USPOKOJENÍ #74 😍
VAŠE DÁVKA USPOKOJENÍ #74 😍HouseBox
zhlédnutí 166K
Unique technique for connecting a garden tap to a plastic pipe without a special coupling #shorts00:31Unique technique for connecting a garden tap to a plastic pipe without a special coupling #shorts
Unique technique for connecting a garden tap to a plastic pipe without a special coupling #shortsSimple Creative
zhlédnutí 10M
Your bathroom needs this00:58Your bathroom needs this
Your bathroom needs thisJustin Flom
zhlédnutí 20M
Střelec na Donalda Trumpa - Thomas Crooks | Co o něm po týdnu víme? | #mscrewpodcast01:00Střelec na Donalda Trumpa - Thomas Crooks | Co o něm po týdnu víme? | #mscrewpodcast
Střelec na Donalda Trumpa - Thomas Crooks | Co o něm po týdnu víme? | #mscrewpodcastMichal Šopor
zhlédnutí 607K
Survive 100 Days In Nuclear Bunker, Win $500,00032:21Survive 100 Days In Nuclear Bunker, Win $500,000
Survive 100 Days In Nuclear Bunker, Win $500,000MrBeast
zhlédnutí 122M
Cane salvato grazie alla prontezza di riflessi dei bambini e all'abilità del veterinario #shorts00:37Cane salvato grazie alla prontezza di riflessi dei bambini e all'abilità del veterinario #shorts
Cane salvato grazie alla prontezza di riflessi dei bambini e all'abilità del veterinario #shortsI migliori trucchetti di Fabiosa
zhlédnutí 2,9M