Power BI - DirectQuery: A Look Under the Hood

preview_player
Показать описание
In this video, we take a look at how DirectQuery executes queries against our SQL Server backend. It becomes apparent that DirectQuery can send a lot of traffic to your datasource depending on the visualizations shown and calculations performed.

To enroll in my introductory or advanced Power BI courses:
  1. BI Elite
  2. Power BI
  3. Data Analysis
  4. Data Visualization
  5. Data Science
  6. Business Intelligence
Рекомендации по теме
Power BI Get 0:08:31

Power BI Get Data: Import vs. DirectQuery vs. Live (2021)

Import vs DirectQuery 0:07:24

Import vs DirectQuery in Power BI

DirectQuery Connection in 0:16:10

DirectQuery Connection in Power BI How does it work Limitations and Advantages

Power BI : 0:07:13

Power BI : Import VS Direct Query VS Live connection (n'hésite plus)

Power BI query 0:07:51

Power BI query reduction when using DirectQuery

Honestly, DirectQuery is 0:00:51

Honestly, DirectQuery is for the rich!

Power BI Import 0:04:17

Power BI Import oder Direct Query?

Power BI - 0:21:33

Power BI - What You Need to Know About Direct Query

#FabricCoffee with Amit 1:08:25

#FabricCoffee with Amit Chandak - Microsoft Fabric Direct Lake Semantic Mode Row-Level Security(RLS)

Power BI How 0:12:10

Power BI How to switch between Direct Query and Import across data sources

Avoid Left Outer 0:04:39

Avoid Left Outer Joins with DirectQuery in Power BI

Power BI - 0:13:35

Power BI - Import vs Direct Query vs Live Connection

Import vs Direct 0:07:07

Import vs Direct Query in Power BI // What's the difference?

What is Direct 0:01:55

What is Direct Query vs Import (Power BI)? Simply Explained

RLS in the 0:05:05

RLS in the source? How does this work with DirectQuery and Import in Power BI?

Power BI Direct 0:10:50

Power BI Direct Query vs Modo Importar

Power BI Tutorial 0:12:02

Power BI Tutorial (28/50) - What is Import Mode vs DirectQuery Mode

Power BI - 0:10:53

Power BI - DirectQuery: A Look Under the Hood

Difference between Direct 0:05:20

Difference between Direct Query and Import in Power BI | Power BI Interview Question

Speed up Power 0:04:34

Speed up Power BI Direct Query with One Click

PBIMCR - Direct 1:02:52

PBIMCR - Direct Query with Chris Webb

DirectQuery for Power 0:14:01

DirectQuery for Power BI dataset How does it work

Composite models in 0:06:36

Composite models in Power BI and Storage modes - what to pick???

How to create 0:04:48

How to create Direct Query in Power BI | Power BI Tutorial for Beginners

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

Awesome video! Do you think the same things happen when using an imported database? I'm trying to understand how Power BI handles table relations and filters in a dashboard "under the hood". Please reach out to me!

wesverheijen
Автор

how to use rankx function in directquery mode without compromising with the measure i.e without enableing unrestricted measure

Pranav-fgjr
Автор

I have to find top 25 job analyst titles from over 2 crore records, I have tried in direct query mode where there is limitation of 10m rows only and in import mode, power BI app crashed always. Can you please suggest me any solutions

Pranav-fgjr