569 - You type a number into the visual and hit save. For a second or two that number doesn't match anything real while a message travels to a SQL database and the view catches up.
youtu.be/CgJZcVpYLJo
#powerbi #writeback #directquery #sql #datamodeling
youtu.be/CgJZcVpYLJo
#powerbi #writeback #directquery #sql #datamodeling
October 18, 2026 at 9:06 PM
569 - You type a number into the visual and hit save. For a second or two that number doesn't match anything real while a message travels to a SQL database and the view catches up.
youtu.be/CgJZcVpYLJo
#powerbi #writeback #directquery #sql #datamodeling
youtu.be/CgJZcVpYLJo
#powerbi #writeback #directquery #sql #datamodeling
Power BI Architecture Choices for Azure Databricks (w/ Liping Huang) by Reid Havens
https://www.havensconsulting.net/blog-and-media/ls-power-bi-and-databricks?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://www.havensconsulting.net/blog-and-media/ls-power-bi-and-databricks?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
Power BI Architecture Choices for Azure Databricks (w/ Liping Huang) by Reid Havens
LIVESTREAM DATE/TIME 📅 October 16th 2026 - 9:30 AM (Pacific Time) DESCRIPTION 📄 Power BI gives you four main ways to report on data that lives in Azure Databricks: Direct Lake on OneLake, Direct Lake over mirrored Unity Catalog tables, DirectQuery against a Databricks SQL warehouse, and a co
www.havensconsulting.net
October 13, 2026 at 11:05 AM
Power BI Architecture Choices for Azure Databricks (w/ Liping Huang) by Reid Havens
https://www.havensconsulting.net/blog-and-media/ls-power-bi-and-databricks?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://www.havensconsulting.net/blog-and-media/ls-power-bi-and-databricks?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
September 19, 2026 at 5:06 PM
6) Thou shalt Star Schema
7) Thou shalt query fold
8) Thou shalt go as upstream as possible, as downstream as necessary
9) Thou shalt reduce rows and columns
10) Thou shalt avoid DirectQuery
7) Thou shalt query fold
8) Thou shalt go as upstream as possible, as downstream as necessary
9) Thou shalt reduce rows and columns
10) Thou shalt avoid DirectQuery
January 9, 2025 at 10:08 PM
6) Thou shalt Star Schema
7) Thou shalt query fold
8) Thou shalt go as upstream as possible, as downstream as necessary
9) Thou shalt reduce rows and columns
10) Thou shalt avoid DirectQuery
7) Thou shalt query fold
8) Thou shalt go as upstream as possible, as downstream as necessary
9) Thou shalt reduce rows and columns
10) Thou shalt avoid DirectQuery
Then probably compare it to import as well as DirectQuery against the SQL endpoint 🤮. I'd large semantic models and on-demand load to be a fair comparison, I think.
learn.microsoft.com/en-us/power-...
2/2
learn.microsoft.com/en-us/power-...
2/2
Large semantic models in Power BI Premium - Power BI
The large semantic model storage format allows semantic models in Power BI Premium to grow beyond 10 GB in size.
learn.microsoft.com
November 9, 2024 at 11:31 PM
Then probably compare it to import as well as DirectQuery against the SQL endpoint 🤮. I'd large semantic models and on-demand load to be a fair comparison, I think.
learn.microsoft.com/en-us/power-...
2/2
learn.microsoft.com/en-us/power-...
2/2
modifying the parameter means I have to switch from OneLake to a local model with DirectQuery, but during the transition the parameter is deleted entirely
fantastic, wonderful, glad i'm devoting all these heartbeats to solving it
fantastic, wonderful, glad i'm devoting all these heartbeats to solving it
July 22, 2025 at 5:25 AM
modifying the parameter means I have to switch from OneLake to a local model with DirectQuery, but during the transition the parameter is deleted entirely
fantastic, wonderful, glad i'm devoting all these heartbeats to solving it
fantastic, wonderful, glad i'm devoting all these heartbeats to solving it
Today, I discussed an important #Performance consideration for #PowerBI, which is due to #DirectQuery. I explained why and how it impacts, as well as the myths and misconceptions associated with its use.
Watch the video here:
youtu.be/A43QqYCrOOM
Watch the video here:
youtu.be/A43QqYCrOOM
Power BI Performance Tip - No Direct Query
YouTube video by RADACAD
youtu.be
October 2, 2025 at 10:16 PM
Today, I discussed an important #Performance consideration for #PowerBI, which is due to #DirectQuery. I explained why and how it impacts, as well as the myths and misconceptions associated with its use.
Watch the video here:
youtu.be/A43QqYCrOOM
Watch the video here:
youtu.be/A43QqYCrOOM
Did you know that Live Connection in #PowerBI is different than DirectQuery and Import Data? Did you know that some of the differences are so important that they make Live connection an essential architecture for team development in an enterprise environment?
youtu.be/koV0EunuPbQ
youtu.be/koV0EunuPbQ
Power BI Live Connection Demystified
YouTube video by RADACAD
youtu.be
September 25, 2025 at 4:41 PM
Did you know that Live Connection in #PowerBI is different than DirectQuery and Import Data? Did you know that some of the differences are so important that they make Live connection an essential architecture for team development in an enterprise environment?
youtu.be/koV0EunuPbQ
youtu.be/koV0EunuPbQ
Here is my first video of the #Performance #Performancetuning #PowerBI about #aggregations
This is helpful no matter if you use DirectQuery, Composite model, Import Data, and even Direct Lake in #Fabric
watch it here:
youtu.be/fw56vPYdVYc
This is helpful no matter if you use DirectQuery, Composite model, Import Data, and even Direct Lake in #Fabric
watch it here:
youtu.be/fw56vPYdVYc
Power BI Performance Tuning Aggregation Part 1 Overview
YouTube video by RADACAD
youtu.be
November 2, 2024 at 8:29 PM
Here is my first video of the #Performance #Performancetuning #PowerBI about #aggregations
This is helpful no matter if you use DirectQuery, Composite model, Import Data, and even Direct Lake in #Fabric
watch it here:
youtu.be/fw56vPYdVYc
This is helpful no matter if you use DirectQuery, Composite model, Import Data, and even Direct Lake in #Fabric
watch it here:
youtu.be/fw56vPYdVYc
How do aggregations supercharge Power BI? Reza Rad, #FabCon speaker, explains creating aggregation tables, configuring functions, and testing them for faster DirectQuery performance. Essential for data modelers, BI analysts, and Power BI developers. Read his post:
Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action
Learn how to configure the manage aggregations in Power BI and test the performance of it by using aggregations in the report.
buff.ly
March 6, 2025 at 9:11 PM
How do aggregations supercharge Power BI? Reza Rad, #FabCon speaker, explains creating aggregation tables, configuring functions, and testing them for faster DirectQuery performance. Essential for data modelers, BI analysts, and Power BI developers. Read his post:
Check out my latest blog and video on how to integrate #PowerApps with #MicrosoftFabric Warehouse and enable writebacks for #PowerBI reports using #DirectQuery or #DirectLake models! youtube.com/watch?v=exJW...
shabnamwatson.com/2024/10/26/u...
shabnamwatson.com/2024/10/26/u...
November 4, 2024 at 3:10 PM
Check out my latest blog and video on how to integrate #PowerApps with #MicrosoftFabric Warehouse and enable writebacks for #PowerBI reports using #DirectQuery or #DirectLake models! youtube.com/watch?v=exJW...
shabnamwatson.com/2024/10/26/u...
shabnamwatson.com/2024/10/26/u...
DirectQuery over Dremio Cloud on top of Iceberg files.
December 31, 2024 at 6:05 AM
DirectQuery over Dremio Cloud on top of Iceberg files.
Power BI with DuckDB, 4 years later
600 M rows under 4 seconds in Direct Query mode ( warm run)
datamonkeysite.com/2026/05/19/p...
#onelake #apacheiceberg #PowerBI #duckdb #PowerQuery #ADBC
600 M rows under 4 seconds in Direct Query mode ( warm run)
datamonkeysite.com/2026/05/19/p...
#onelake #apacheiceberg #PowerBI #duckdb #PowerQuery #ADBC
Power BI with DuckDB, 4 years later
Four years ago I wrote a blog about using DuckDB with Power BI in DirectQuery. It got a fair number of likes on LinkedIn :) along with the one comment I didn’t want to hear: how does this wor…
datamonkeysite.com
May 19, 2026 at 10:17 AM
Power BI with DuckDB, 4 years later
600 M rows under 4 seconds in Direct Query mode ( warm run)
datamonkeysite.com/2026/05/19/p...
#onelake #apacheiceberg #PowerBI #duckdb #PowerQuery #ADBC
600 M rows under 4 seconds in Direct Query mode ( warm run)
datamonkeysite.com/2026/05/19/p...
#onelake #apacheiceberg #PowerBI #duckdb #PowerQuery #ADBC
Reading: Enabling real-time dashboards: Power BI DirectQuery mode and Dataflows support in #Azure Cosmos DB - https://bit.ly/42iypi1 #AzureData #PowerBI #CosmosDB
Enabling real-time dashboards: Power BI DirectQuery mode ...
Now we are announcing the preview of the Azure Cosmos DB ...
bit.ly
November 21, 2024 at 9:36 PM
Reading: Enabling real-time dashboards: Power BI DirectQuery mode and Dataflows support in #Azure Cosmos DB - https://bit.ly/42iypi1 #AzureData #PowerBI #CosmosDB
Implementing #OneLake #Shortcuts and #Caching between #Fabric and #GoogleCloudStorage to re-design architecture to centralize and better predict costs improving performance in #PowerBI #DirectLake models.
medium.com/riccardo-per...
medium.com/riccardo-per...
Integrating Microsoft Fabric with Google Cloud Storage in the real-world
An architecture redesign to overcome DirectQuery headaches
medium.com
April 24, 2026 at 6:57 AM
Implementing #OneLake #Shortcuts and #Caching between #Fabric and #GoogleCloudStorage to re-design architecture to centralize and better predict costs improving performance in #PowerBI #DirectLake models.
medium.com/riccardo-per...
medium.com/riccardo-per...
AI-driven querying multiplies DirectQuery warehouse queries into dozens or hundreds, causing performance slowdowns and higher cloud costs, and vendors recommend using Import mode for cached decision cadences or Direct Lake/governed ingestion pipelines (e.g., Microsoft Fabric) to scale.
AI Is About to Break Your BI Architecture (If You Don't Redesign It First) | HackerNoon
AI is about to expose weak BI architecture. "DirectQuery" collapses under machine curiosity. Decision-aligned design is the only way forward.
hackernoon.com
February 23, 2026 at 2:17 PM
AI-driven querying multiplies DirectQuery warehouse queries into dozens or hundreds, causing performance slowdowns and higher cloud costs, and vendors recommend using Import mode for cached decision cadences or Direct Lake/governed ingestion pipelines (e.g., Microsoft Fabric) to scale.
An early (and admittedly bad) public preview title, worse than I remember too:
"DirectQuery for Power BI Datasets and Azure Analysis Services" - DQfPBIdsAAS or something-something.
It's now just a part of "composite models" and a live connection to a remote model.
www.linkedin.com/pulse/direct...
"DirectQuery for Power BI Datasets and Azure Analysis Services" - DQfPBIdsAAS or something-something.
It's now just a part of "composite models" and a live connection to a remote model.
www.linkedin.com/pulse/direct...
DirectQuery for Power BI Datasets and Azure Analysis Services: Expanding Data Connectivity
Modern organizations rely on data from multiple systems, but combining that data without duplication or IT dependency has always been a challenge. That’s where DirectQuery for Power BI Datasets and Az...
www.linkedin.com
April 17, 2026 at 3:52 AM
An early (and admittedly bad) public preview title, worse than I remember too:
"DirectQuery for Power BI Datasets and Azure Analysis Services" - DQfPBIdsAAS or something-something.
It's now just a part of "composite models" and a live connection to a remote model.
www.linkedin.com/pulse/direct...
"DirectQuery for Power BI Datasets and Azure Analysis Services" - DQfPBIdsAAS or something-something.
It's now just a part of "composite models" and a live connection to a remote model.
www.linkedin.com/pulse/direct...
Back in the day the composite models were called DirectQuery over Power BI semantic models (DQoPBIsm) or something like that - so it could just be the date of the recorded material.
It's essentially a live connection in all the ways that matter.
It's essentially a live connection in all the ways that matter.
April 17, 2026 at 3:40 AM
Back in the day the composite models were called DirectQuery over Power BI semantic models (DQoPBIsm) or something like that - so it could just be the date of the recorded material.
It's essentially a live connection in all the ways that matter.
It's essentially a live connection in all the ways that matter.
I’m ok with that. Also there’s plans to bring it down more.
If you need real-time results I always suggest using the built in charts of Dataverse or DirectQuery.
@scottsewell.bsky.social has some real-time event streams built for Dataverse event triggers too.
Many options depending upon the need.
If you need real-time results I always suggest using the built in charts of Dataverse or DirectQuery.
@scottsewell.bsky.social has some real-time event streams built for Dataverse event triggers too.
Many options depending upon the need.
February 2, 2025 at 2:42 PM
I’m ok with that. Also there’s plans to bring it down more.
If you need real-time results I always suggest using the built in charts of Dataverse or DirectQuery.
@scottsewell.bsky.social has some real-time event streams built for Dataverse event triggers too.
Many options depending upon the need.
If you need real-time results I always suggest using the built in charts of Dataverse or DirectQuery.
@scottsewell.bsky.social has some real-time event streams built for Dataverse event triggers too.
Many options depending upon the need.
Likely a small Azure SQL DB with DirectQuery and Pro licensing would be a better mix if we’re talking purely cost and need for a SQL endpoint.
Otherwise Pro + F2 roughly to get you in at sub $400 USD a month, but with ability to create more items with Fabric.
1/N
Otherwise Pro + F2 roughly to get you in at sub $400 USD a month, but with ability to create more items with Fabric.
1/N
August 9, 2024 at 2:16 AM
Likely a small Azure SQL DB with DirectQuery and Pro licensing would be a better mix if we’re talking purely cost and need for a SQL endpoint.
Otherwise Pro + F2 roughly to get you in at sub $400 USD a month, but with ability to create more items with Fabric.
1/N
Otherwise Pro + F2 roughly to get you in at sub $400 USD a month, but with ability to create more items with Fabric.
1/N
We Built Dashboards for the Business. Then the Cloud Bill Built One for Us.
We discovered our BI architecture was quietly burning money.
Two structural fixes - splitting giant 500M-row models into optimized pieces and replacing real-time DirectQuery with a 5-minute hybrid import …
#hackernews #news
We discovered our BI architecture was quietly burning money.
Two structural fixes - splitting giant 500M-row models into optimized pieces and replacing real-time DirectQuery with a 5-minute hybrid import …
#hackernews #news
We Built Dashboards for the Business. Then the Cloud Bill Built One for Us.
We discovered our BI architecture was quietly burning money.
Two structural fixes - splitting giant 500M-row models into optimized pieces and replacing real-time DirectQuery with a 5-minute hybrid import model - cut our BigQuery spend from ~$545/day to ~$260/day.
In 90 days, we saved ~$110K annually, stabilized performance, and kept dashboards feeling real-time.
The lesson: BI isn’t a project. It’s continuous refinement, curiosity, and intentional design.
hackernoon.com
November 27, 2025 at 3:18 AM
We Built Dashboards for the Business. Then the Cloud Bill Built One for Us.
We discovered our BI architecture was quietly burning money.
Two structural fixes - splitting giant 500M-row models into optimized pieces and replacing real-time DirectQuery with a 5-minute hybrid import …
#hackernews #news
We discovered our BI architecture was quietly burning money.
Two structural fixes - splitting giant 500M-row models into optimized pieces and replacing real-time DirectQuery with a 5-minute hybrid import …
#hackernews #news
Power BIのダイレクトクエリで人気な7つのコネクター
Microsoft Power BI のDirectQuery って便利ですよね。 通常はPower BI ではDB やDWH のデータを一度Power BI Desktop に取り込んでからPower BI で分析利用します。これをImport Mode と呼びます。これに対し、DB やDWH 側のデータ量が多い場合には、Power BI に一度データを全部取り込むということが効率的ではないです（現実的でもない）。そのためにPower BI ではDirectQuery（ダイレクトクエリ）Mode…
Microsoft Power BI のDirectQuery って便利ですよね。 通常はPower BI ではDB やDWH のデータを一度Power BI Desktop に取り込んでからPower BI で分析利用します。これをImport Mode と呼びます。これに対し、DB やDWH 側のデータ量が多い場合には、Power BI に一度データを全部取り込むということが効率的ではないです（現実的でもない）。そのためにPower BI ではDirectQuery（ダイレクトクエリ）Mode…
Power BIのダイレクトクエリで人気な7つのコネクター
Microsoft Power BI のDirectQuery って便利ですよね。 通常はPower BI ではDB やDWH のデータを一度Power BI Desktop に取り込んでからPower BI で分析利用します。これをImport Mode と呼びます。これに対し、DB やDWH 側のデータ量が多い場合には、Power BI に一度データを全部取り込むということが効率的ではないです（現実的でもない）。そのためにPower BI ではDirectQuery（ダイレクトクエリ）Mode が用意されていて、データソースにあるデータをPower BI から直接クエリして分析利用できます。この便利なDirectQuery 機能を、CData が提供するCData Power BI Connectors シリーズではフルサポートしています。この記事では、DirectQuery の用途で人気のCData コネクタを紹介します！ Power BI のDirectQuery とは？ Power BI Desktop でデータを分析する際には、基本的にデータを一度Power BI Desktop に取り込んでから分析を行います。これにより、Power BI のハイパフォーマンスなクエリエンジンを利用したデータ分析、データ活用が可能になります。この方法をImport Mode（インポートモード）と呼んでいます。しかし、集計する対象となるデータが大きく、Power BI Desktop にインポートして利用することが現実的でない場合などのために、Power BI 側にデータソースを取り込むことなく、DB やDWH にあるデータをPower BI で直接分析利用する方法があります。これをDirectQuery Mode と呼びます。 Power BI でDirectQuery を使うためには、データ取り込み時にラジオボタンでDirectQuery を選択します。多くの場合、データのAggregation（集計）結果を返すような使い方のイメージです。すごく細かいデータが大量にあって全レコードをインポートして分析するのではなく（それができるデータ量ならインポートモードでやればいいわけで）、全レコードからのAggregation のクエリを結果（データ全体に対して相当小さい）だけをPower BI で受け取って分析に使います。 ■DirectQuery はどんな時に使われますか（メリット）？ データが大容量：DirectQuery は、まず集計対象のデータが大きすぎる場合に使われます。Google BigQuery やSnowflake など大容量のデータを保存している場合には、Power BI に集計前のデータを全量取り込むことは現実的ではありません。DirectQuery を使うことで、大容量のデータに対してもPower BI から集計をかけることが可能になります。 リアルタイムに近いデータ：Power BI でリアルタイムに近いデータを分析したい場合にもDirectQuery が使われます。Power BI には、インポートデータのリフレッシュの回数制限（Power BI Pro では、1日8回）があります。準リアルタイムのデータ利用では、限界がでてしまいます。DirectQuery を使うと、レポートまたはダッシュボードを開くか更新したときに、ソースの最新データが常に表示されます。 また、ダッシュボードのタイルの更新をさらに頻繁に行うこともできます (最高で 15 分ごと)。
inmobilexion.com
April 14, 2025 at 1:07 AM
Power BIのダイレクトクエリで人気な7つのコネクター
Microsoft Power BI のDirectQuery って便利ですよね。 通常はPower BI ではDB やDWH のデータを一度Power BI Desktop に取り込んでからPower BI で分析利用します。これをImport Mode と呼びます。これに対し、DB やDWH 側のデータ量が多い場合には、Power BI に一度データを全部取り込むということが効率的ではないです（現実的でもない）。そのためにPower BI ではDirectQuery（ダイレクトクエリ）Mode…
Microsoft Power BI のDirectQuery って便利ですよね。 通常はPower BI ではDB やDWH のデータを一度Power BI Desktop に取り込んでからPower BI で分析利用します。これをImport Mode と呼びます。これに対し、DB やDWH 側のデータ量が多い場合には、Power BI に一度データを全部取り込むということが効率的ではないです（現実的でもない）。そのためにPower BI ではDirectQuery（ダイレクトクエリ）Mode…
📰 **Microsoft Entra ID single sign-on for the Denodo connector in Power BI (Preview)**
When you configure a Denodo data connection for Entra ID SSO, users querying a semantic model in DirectQuery mode are authenticated to Denodo with their own Microsoft Entra ID identity.
📰 Source: Power BI […]
When you configure a Denodo data connection for Entra ID SSO, users querying a semantic model in DirectQuery mode are authenticated to Denodo with their own Microsoft Entra ID identity.
📰 Source: Power BI […]
Original post on igeek.gamer-geek-news.com
igeek.gamer-geek-news.com
June 23, 2026 at 9:00 PM
📰 **Microsoft Entra ID single sign-on for the Denodo connector in Power BI (Preview)**
When you configure a Denodo data connection for Entra ID SSO, users querying a semantic model in DirectQuery mode are authenticated to Denodo with their own Microsoft Entra ID identity.
📰 Source: Power BI […]
When you configure a Denodo data connection for Entra ID SSO, users querying a semantic model in DirectQuery mode are authenticated to Denodo with their own Microsoft Entra ID identity.
📰 Source: Power BI […]
📰 **Microsoft Entra ID single sign-on for the Starburst connector in Power BI (Preview)**
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode authenticate to Starburst with their own Entra ID identity,...
📰 […]
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode authenticate to Starburst with their own Entra ID identity,...
📰 […]
Original post on igeek.gamer-geek-news.com
igeek.gamer-geek-news.com
June 18, 2026 at 4:11 PM
📰 **Microsoft Entra ID single sign-on for the Starburst connector in Power BI (Preview)**
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode authenticate to Starburst with their own Entra ID identity,...
📰 […]
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode authenticate to Starburst with their own Entra ID identity,...
📰 […]
Conexión a SQL Server desde Power BI: modos de consulta, parámetros y buenas prácticas
En la clase del 18 de junio, dentro del curso de certificación PL-300 de NamasData , abordamos uno de los temas más importantes para rendir bien en el examen… y para construir modelos de datos eficientes en…
En la clase del 18 de junio, dentro del curso de certificación PL-300 de NamasData , abordamos uno de los temas más importantes para rendir bien en el examen… y para construir modelos de datos eficientes en…
Conexión a SQL Server desde Power BI: modos de consulta, parámetros y buenas prácticas
En la clase del 18 de junio, dentro del curso de certificación PL-300 de NamasData , abordamos uno de los temas más importantes para rendir bien en el examen… y para construir modelos de datos eficientes en proyectos reales: 👉 la conexión de Power BI con bases de datos SQL Server, y las diferencias entre los modos Importación, DirectQuery y Dual.
formacionbi.com
June 19, 2025 at 6:45 AM
Conexión a SQL Server desde Power BI: modos de consulta, parámetros y buenas prácticas
En la clase del 18 de junio, dentro del curso de certificación PL-300 de NamasData , abordamos uno de los temas más importantes para rendir bien en el examen… y para construir modelos de datos eficientes en…
En la clase del 18 de junio, dentro del curso de certificación PL-300 de NamasData , abordamos uno de los temas más importantes para rendir bien en el examen… y para construir modelos de datos eficientes en…