A look at the impact of calendar-based time intelligence on #PowerBI DirectQuery performance blog.crossjoin.co.uk/2025/11/30/a...
Impact of Calendar Based Time Intelligence on Power BI DirectQuery performance
Significant performance improvements are possible but not in all cases
blog.crossjoin.co.uk
December 1, 2025 at 8:31 AM
A look at the impact of calendar-based time intelligence on #PowerBI DirectQuery performance blog.crossjoin.co.uk/2025/11/30/a...
Power BI DirectQuery mode: a better choice than you might think blog.crossjoin.co.uk/2026/06/28/p...
Power BI DirectQuery mode: a better choice than you might think
Using DirectQuery on Fabric Warehouse or the SQL Endpoint of a Lakehouse is great for large data volumes
blog.crossjoin.co.uk
June 28, 2026 at 9:50 PM
Power BI DirectQuery mode: a better choice than you might think blog.crossjoin.co.uk/2026/06/28/p...
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
These slides are from @cwebbbi.bsky.social's EXCELLENT presentation that anyone considering implementing DirectQuery should have to be able to recite verbatim before they start their likely fruitless journey.
I mean...c'mon... Chris' face says it all here.
blog.crossjoin.co.uk/2023/05/07/p...
I mean...c'mon... Chris' face says it all here.
blog.crossjoin.co.uk/2023/05/07/p...
Power BI DirectQuery best practices
Video of a user group presentation on Power BI DirectQuery best practices
blog.crossjoin.co.uk
September 10, 2024 at 6:28 AM
These slides are from @cwebbbi.bsky.social's EXCELLENT presentation that anyone considering implementing DirectQuery should have to be able to recite verbatim before they start their likely fruitless journey.
I mean...c'mon... Chris' face says it all here.
blog.crossjoin.co.uk/2023/05/07/p...
I mean...c'mon... Chris' face says it all here.
blog.crossjoin.co.uk/2023/05/07/p...
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 DirectQuery, Gateways And SQL Queries That Return Lots Of Rows by Chris Webb https://blog.crossjoin.co.uk/2024/08/04/power-bi-directquery-gateways-and-sql-queries-that-return-lots-of-rows/?utm_source=rss&utm_medium=rss&utm_campaign=power-bi-directquery-gateways-and-sql-queries-that…
Power BI DirectQuery, gateways and SQL queries that return lots of rows
Turning on the StreamBeforeRequestCompletes setting on a gateway can help DirectQuery performance
blog.crossjoin.co.uk
August 8, 2024 at 10:55 AM
Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows by Chris Webb https://blog.crossjoin.co.uk/2024/08/04/power-bi-directquery-gateways-and-sql-queries-that-return-lots-of-rows/?utm_source=rss&utm_medium=rss&utm_campaign=power-bi-directquery-gateways-and-sql-queries-that…
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
Your fault for using DirectQuery :)
October 22, 2025 at 10:46 AM
Your fault for using DirectQuery :)
Do you know that you can directly convert from "import" to "directQuery" mode with the #TMDL editor without needing to recreate the table in Power Query? #MSPowerBI
July 2, 2025 at 3:34 PM
Do you know that you can directly convert from "import" to "directQuery" mode with the #TMDL editor without needing to recreate the table in Power Query? #MSPowerBI
Diagnosing #PowerBI DirectQuery connection limit problems with Performance Analyzer blog.crossjoin.co.uk/2025/12/28/d...
Diagnosing Power BI DirectQuery connection limit problems with Performance Analyzer
See when a DirectQuery report is slow because there are limited connections back to the source
blog.crossjoin.co.uk
December 29, 2025 at 1:15 PM
Diagnosing #PowerBI DirectQuery connection limit problems with Performance Analyzer blog.crossjoin.co.uk/2025/12/28/d...
"Lesson Learned #524: Optimizing Power BI with DirectQuery" buff.ly/M3xy7jQ #Microsoft #techcommunity
Lesson Learned #524: Optimizing Power BI with DirectQuery | Microsoft Community Hub
In some situations, customers that are using Power BI and DirectQuery reported performance issues depending on how the query has been defined by Power BI. At...
buff.ly
July 2, 2025 at 10:36 AM
"Lesson Learned #524: Optimizing Power BI with DirectQuery" buff.ly/M3xy7jQ #Microsoft #techcommunity
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
What Power BI DirectQuery does to your SQL Server (and how to fix it) by Kat Korson #PowerBI www.sqlservercentral.com/articles/wha...
What Power BI DirectQuery does to your SQL Server (and how to fix it) – SQLServerCentral
Power BI DirectQuery can quietly overwhelm your SQL Server. Unlike Import mode, DirectQuery sends live T-SQL for every visual interaction, multiplying queries and placing heavy analytical load on the...
www.sqlservercentral.com
April 27, 2026 at 12:05 PM
What Power BI DirectQuery does to your SQL Server (and how to fix it) by Kat Korson #PowerBI www.sqlservercentral.com/articles/wha...
September 19, 2026 at 5:06 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 […]
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 […]
#PowerBI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows by Chris Webb https://buff.ly/3WYKQim…
Power BI DirectQuery, gateways and SQL queries that return lots of rows
Turning on the StreamBeforeRequestCompletes setting on a gateway can help DirectQuery performance
blog.crossjoin.co.uk
August 16, 2024 at 11:00 AM
#PowerBI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows by Chris Webb https://buff.ly/3WYKQim…
Drillthrough in #excel now supported for Direct Lake and DirectQuery Models by Kay Unkroth #PowerBI powerbi.microsoft.com/en-us/blog/d...
Drillthrough in Excel now supported for Direct Lake and DirectQuery Models
The previous limitation preventing drillthrough (via Excel’s Show Details feature when using Analyze in Excel) on Direct Lake and DirectQuery semantic model has been removed.
powerbi.microsoft.com
December 11, 2025 at 2:10 PM
Drillthrough in #excel now supported for Direct Lake and DirectQuery Models by Kay Unkroth #PowerBI powerbi.microsoft.com/en-us/blog/d...
Diagnosing #PowerBI DirectQuery performance problems caused by SQL queries that return large resultsets blog.crossjoin.co.uk/2026/01/04/d...
Diagnosing Power BI DirectQuery performance problems caused by SQL queries that return large resultsets
Large resultsets can be slow to read
blog.crossjoin.co.uk
January 4, 2026 at 11:22 AM
Diagnosing #PowerBI DirectQuery performance problems caused by SQL queries that return large resultsets blog.crossjoin.co.uk/2026/01/04/d...
What happens when #PowerBI Direct Lake models hit guardrails? blog.crossjoin.co.uk/2025/09/07/w...
What happens when Power BI Direct Lake models hit guardrails?
It depends on the type of Direct Lake model but you will either get warnings or errors and the model will fall back to DirectQuery if it can
blog.crossjoin.co.uk
September 7, 2025 at 8:44 AM
What happens when #PowerBI Direct Lake models hit guardrails? blog.crossjoin.co.uk/2025/09/07/w...
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
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...
Hey #PowerBI peeps...I'm confused by the terminology Alberto is using here. He's talking about a live connection to a remote model, but the slide says "AS DirectQuery Island"
Should that read "AS LiveConnect Island"?
Should that read "AS LiveConnect Island"?
April 16, 2026 at 9:17 PM
Hey #PowerBI peeps...I'm confused by the terminology Alberto is using here. He's talking about a live connection to a remote model, but the slide says "AS DirectQuery Island"
Should that read "AS LiveConnect Island"?
Should that read "AS LiveConnect Island"?
AI is about to expose weak BI architecture. "DirectQuery" collapses under machine curiosity. Decision-aligned design is the only way forward. #artificialintelligence
AI Is About to Break Your BI Architecture (If You Don't Redesign It First)
hackernoon.com
February 23, 2026 at 1:57 AM
AI is about to expose weak BI architecture. "DirectQuery" collapses under machine curiosity. Decision-aligned design is the only way forward. #artificialintelligence