Chris Webb
@cwebbbi.bsky.social
I work at Microsoft on the Fabric CAT team. Posts are my own.
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...
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...
Visualising #PowerBI Performance Analyzer data with a vibe-coded custom visual blog.crossjoin.co.uk/2025/12/21/v...
Visualising Power BI Performance Analyzer data with a vibe-coded custom visual
How Performance Analyzer data exports can be visualised in Power BI using a custom visual
blog.crossjoin.co.uk
December 21, 2025 at 5:50 PM
Visualising #PowerBI Performance Analyzer data with a vibe-coded custom visual blog.crossjoin.co.uk/2025/12/21/v...
#PowerBI Copilot and report filters and slicers blog.crossjoin.co.uk/2025/12/14/p...
Power BI Copilot and report filters and slicers
How report filters and slicers influence how Copilot answers questions
blog.crossjoin.co.uk
December 14, 2025 at 4:00 PM
#PowerBI Copilot and report filters and slicers blog.crossjoin.co.uk/2025/12/14/p...
Stopping #PowerBI Copilot from answering questions from report visuals blog.crossjoin.co.uk/2025/12/07/s...
Stopping Power BI Copilot from answering questions from report visuals
AI Instructions can force Copilot to get answers from the semantic model instead of the report
blog.crossjoin.co.uk
December 7, 2025 at 7:03 PM
Stopping #PowerBI Copilot from answering questions from report visuals blog.crossjoin.co.uk/2025/12/07/s...
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...
#PowerBI Build permissions and security blog.crossjoin.co.uk/2025/11/23/p...
Power BI, Build permissions and security
Build permissions are not security!
blog.crossjoin.co.uk
November 23, 2025 at 5:48 PM
#PowerBI Build permissions and security blog.crossjoin.co.uk/2025/11/23/p...
Linking queries run from DAX Studio to Workspace Monitoring and the Capacity Metrics app blog.crossjoin.co.uk/2025/11/16/l...
Linking queries run from DAX Studio to Workspace Monitoring and the Capacity Metrics app
The RequestId value in DAX Studio's Server Timings is the same thing as the OperationId
blog.crossjoin.co.uk
November 16, 2025 at 7:24 PM
Linking queries run from DAX Studio to Workspace Monitoring and the Capacity Metrics app blog.crossjoin.co.uk/2025/11/16/l...
Calling DAX UDFs from #PowerBI Copilot blog.crossjoin.co.uk/2025/11/09/c...
Calling DAX UDFs from Power BI Copilot
An example showing how Copilot can call a DAX UDF that does ABC analysis
blog.crossjoin.co.uk
November 9, 2025 at 2:35 PM
Calling DAX UDFs from #PowerBI Copilot blog.crossjoin.co.uk/2025/11/09/c...
Monitoring the DAX queries generated when the #PowerBI Copilot index is built blog.crossjoin.co.uk/2025/11/02/m...
Monitoring the DAX queries generated when the Power BI Copilot index is built
The DAX queries get all the distinct values less than 100 characters long from text columns
blog.crossjoin.co.uk
November 2, 2025 at 5:51 PM
Monitoring the DAX queries generated when the #PowerBI Copilot index is built blog.crossjoin.co.uk/2025/11/02/m...
Understanding the “Copilot analyzed only part of this model due to its size” warning in #PowerBI blog.crossjoin.co.uk/2025/10/26/u...
Understanding the "Copilot analyzed only part of the model due to its size" warning in Power BI Copilot
Learn how to control which columns Copilot indexes
blog.crossjoin.co.uk
October 26, 2025 at 3:50 PM
Understanding the “Copilot analyzed only part of this model due to its size” warning in #PowerBI blog.crossjoin.co.uk/2025/10/26/u...
Monitor Fabric costs with Fabric Cost Analysis blog.crossjoin.co.uk/2025/10/19/m...
Monitor Fabric costs with Fabric Cost Analysis
It's a solution built using Fabric for monitoring Fabric costs
blog.crossjoin.co.uk
October 19, 2025 at 1:47 PM
Monitor Fabric costs with Fabric Cost Analysis blog.crossjoin.co.uk/2025/10/19/m...
First look at Fabric Graph: Analysing #PowerBI Import mode refresh job graphs blog.crossjoin.co.uk/2025/10/12/f...
First look at Fabric Graph: Analysing Power BI Import mode refresh job graphs
Use Fabric's new graph database to analyse the jobs that make up a Power BI Import mode model refresh
blog.crossjoin.co.uk
October 12, 2025 at 7:38 PM
First look at Fabric Graph: Analysing #PowerBI Import mode refresh job graphs blog.crossjoin.co.uk/2025/10/12/f...
Snowflake query tags in #PowerBI and Workspace Monitoring blog.crossjoin.co.uk/2025/10/05/s...
Snowflake query tags in Power BI and Workspace Monitoring
Link a Snowflake query to the Power BI operation that generated it
blog.crossjoin.co.uk
October 5, 2025 at 6:40 PM
Snowflake query tags in #PowerBI and Workspace Monitoring blog.crossjoin.co.uk/2025/10/05/s...
Linking Fabric Warehouse SQL queries and Spark jobs to the Capacity Metrics App blog.crossjoin.co.uk/2025/09/28/l...
Linking Fabric Warehouse SQL queries and Spark jobs to the Capacity Metrics App
The OperationId can be used to find details of a TSQL query or Spark job
blog.crossjoin.co.uk
September 28, 2025 at 9:53 AM
Linking Fabric Warehouse SQL queries and Spark jobs to the Capacity Metrics App blog.crossjoin.co.uk/2025/09/28/l...
Finding #PowerBI queries and refreshes that have been throttled using Workspace Monitoring blog.crossjoin.co.uk/2025/09/21/f...
Finding Power BI queries and refreshes that have been throttled with Workspace Monitoring
The capacityThrottlingMs metric tells you if a query or refresh has been throttled
blog.crossjoin.co.uk
September 21, 2025 at 5:31 PM
Finding #PowerBI queries and refreshes that have been throttled using Workspace Monitoring blog.crossjoin.co.uk/2025/09/21/f...
How to get the details of #PowerBI operations seen in the Capacity Metrics App blog.crossjoin.co.uk/2025/09/14/h...
How to get the details of Power BI operations seen in the Capacity Metrics App
The OperationId column can be used in Workspace Monitoring queries
blog.crossjoin.co.uk
September 14, 2025 at 8:09 AM
How to get the details of #PowerBI operations seen in the Capacity Metrics App blog.crossjoin.co.uk/2025/09/14/h...
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...
Performance testing #PowerBI Direct Lake models revisited: ensuring worst-case performance blog.crossjoin.co.uk/2025/08/31/p...
Performance testing Power BI Direct Lake models revisited: ensuring worst-case performance
You now need to do a refresh of type clearValues followed by a full refresh to page all data out of memory for a Direct Lake model
blog.crossjoin.co.uk
August 31, 2025 at 12:48 PM
Performance testing #PowerBI Direct Lake models revisited: ensuring worst-case performance blog.crossjoin.co.uk/2025/08/31/p...
Useful community tools and resources for #PowerBI and #MicrosoftFabric blog.crossjoin.co.uk/2025/08/24/u...
August 24, 2025 at 6:50 PM
Useful community tools and resources for #PowerBI and #MicrosoftFabric blog.crossjoin.co.uk/2025/08/24/u...
#PowerBI Copilot, AI Instructions and DAX query templates blog.crossjoin.co.uk/2025/08/17/p...
blog.crossjoin.co.uk
August 17, 2025 at 9:26 PM
#PowerBI Copilot, AI Instructions and DAX query templates blog.crossjoin.co.uk/2025/08/17/p...
#PowerBI Copilot, AI Instructions and DAX measure definitions blog.crossjoin.co.uk/2025/08/10/p...
Power BI Copilot, AI Instructions and DAX measure definitions
Adding measure definitions to Copilot AI Instructions helps users understand how measures work
blog.crossjoin.co.uk
August 10, 2025 at 7:26 PM
#PowerBI Copilot, AI Instructions and DAX measure definitions blog.crossjoin.co.uk/2025/08/10/p...
Why do #PowerBI Copilot AI Instructions seem to work better in Desktop than in the Service? blog.crossjoin.co.uk/2025/08/03/w...
Why Power BI Copilot seems to work better in Desktop than in the Service
Changes to AI Instructions are not always applied immediately after publishing
blog.crossjoin.co.uk
August 3, 2025 at 5:38 PM
Why do #PowerBI Copilot AI Instructions seem to work better in Desktop than in the Service? blog.crossjoin.co.uk/2025/08/03/w...
#PowerBI Copilot, AI Instructions and visualisation guidelines blog.crossjoin.co.uk/2025/07/27/p...
Power BI Copilot, AI Instructions and visualisation guidelines
Control which visuals Copilot uses in responses
blog.crossjoin.co.uk
July 27, 2025 at 6:49 PM
#PowerBI Copilot, AI Instructions and visualisation guidelines blog.crossjoin.co.uk/2025/07/27/p...
#PowerBI Copilot, AI Instructions and semantic model relationships blog.crossjoin.co.uk/2025/07/20/p...
Power BI Copilot, AI Instructions and semantic model relationships
Learn how Copilot works with measures and columns on different tables
blog.crossjoin.co.uk
July 21, 2025 at 7:27 AM
#PowerBI Copilot, AI Instructions and semantic model relationships blog.crossjoin.co.uk/2025/07/20/p...