Maintaining Query Folding when Merging with Different Data Types

preview_player
Показать описание
Learn how to maintain your query folding when needing to merge (join) queries in Power Query, but when the merge keys are different data types, and when converting data types might initially break your query folding. Tune in to learn more!

RELATED CONTENT 🔗

BECOME A CHANNEL MEMBER 🎉

CHECK OUT OUR MERCH STORE 👕

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:30 - Content Intro

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #queryfolding
  1. Havens Consulting
  2. Power BI
  3. PowerBI
  4. PBI
  5. DAX
  6. Data Modeling
Рекомендации по теме
Maintaining Query Folding 0:05:14

Maintaining Query Folding when Merging with Different Data Types

Enable QUERY FOLDING 0:04:41

Enable QUERY FOLDING for native queries in Power Query / Power BI

Maintaining Query Folding 0:05:52

Maintaining Query Folding when Distinct Counting in Power Query

OPTIMISE your Data 0:12:35

OPTIMISE your Data Loads using Query Folding // Beginners Guide to Power BI in 2021

Visually see where 0:03:36

Visually see where you BROKE the fold in Power Query

Understand Query folding 0:13:30

Understand Query folding in Power BI in 13 minutes!

Power BI Desktop: 0:05:19

Power BI Desktop: How to find the native query after query folding

Power BI UG 0:48:21

Power BI UG Cologne 20220222 Fold on tight - what is a Query folding and why should I care?

Query Folding in 1:09:09

Query Folding in Power BI by Nikola Ilic Stuttgart PPUG

Keeping Query Folding 0:05:41

Keeping Query Folding by Outsmarting Columns from Examples in Power Query

MSPTDA 11.5 Which 0:03:17

MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature!

Query Folding in 1:07:12

Query Folding in Power BI by Nikola Ilic aka Data Mozart

How Power Query 1:00:51

How Power Query Thinks: Taking the Mystery Out of Streaming and Query Folding - Ben Gribaudo

Microsoft Power BI 0:53:52

Microsoft Power BI UK User Group - Fold on tight - What Is Query Folding? - Nikola Ilic

Power Query in 0:05:52

Power Query in Power BI – 10 TIPS for improved performance and structure

What is query 0:00:22

What is query folding in Power Query | Power BI interview questions and answers #viral #interview

Why is my 0:08:09

Why is my Power BI refresh so SLOW?!? 3 Bottlenecks for refresh performance

Power BI Interview 0:14:25

Power BI Interview Questions and Answers: What is Query Folding in Power BI?

How we optimize 0:12:28

How we optimize Power Query and Power BI Dataflows

Feb 2023 Pushing 1:19:12

Feb 2023 Pushing the Query Folding limits with Power Query

How to improve 0:10:11

How to improve the performance of Power BI report | Query folding | Power BI tutorial for beginners

Using Query Folding 0:57:23

Using Query Folding to Improve Power BI Performance

What is Query 0:09:53

What is Query Folding & Query Diagnostics in Power BI |How to Fix performance issues in Power BI

5 Best Practices 0:11:31

5 Best Practices in Power Query

Комментарии
Автор

This could useful. I like my queries to fold.

MilhouseBS
Автор

Nice video. Better you could zoom in the focused frames.

OneNI
Автор

Reid, isn't best practice is to write SQL Query instead of checking whether Query will fold or not?

Baldur
Автор

What is so special about query folding? Why we should care about it? Incremental refresh works without query folding. Some folks say, it is quicker. But how can "Select * from Table1" writen by me (which does not fold) be slower than same thing written by the engine?

yyymmmddd