Chris Webb
cwebbbi.bsky.social
Chris Webb
@cwebbbi.bsky.social
I work at Microsoft on the Fabric CAT team. Posts are my own.
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
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
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
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
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
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
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
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
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
Useful community tools and resources for #PowerBI and #MicrosoftFabric blog.crossjoin.co.uk/2025/08/24/u...
August 24, 2025 at 6:50 PM
#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 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
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
#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 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 dealing with ambiguity blog.crossjoin.co.uk/2025/07/13/p...
Power BI Copilot, AI Instructions and dealing with ambiguity
Make Copilot ask for clarification instead of guessing so often
blog.crossjoin.co.uk
July 13, 2025 at 4:47 PM
#PowerBI Copilot, AI Instructions and preventing the use of implicit measures blog.crossjoin.co.uk/2025/07/06/p...
Power BI Copilot, AI Instructions and preventing the use of implicit measures
Stop Copilot from aggregating data itself
blog.crossjoin.co.uk
July 6, 2025 at 4:22 PM
#PowerBI Copilot AI Instructions: helping users understand the scope of the data blog.crossjoin.co.uk/2025/06/22/p...
Power BI Copilot AI Instructions: helping users understand the scope of the data
Instruct Copilot to tell the user what data is and isn't present in a semantic model
blog.crossjoin.co.uk
June 22, 2025 at 5:20 PM
Had an amazing time at #SQLBits as always. Many thanks to the organisers, helpers, speakers, sponsors and of course the attendees!
June 21, 2025 at 6:09 PM
Join the Fabric User Research Panel! blog.crossjoin.co.uk/2025/06/17/j...
June 17, 2025 at 6:42 PM
Grouping and filtering in #PowerBI Copilot AI Instructions blog.crossjoin.co.uk/2025/06/15/g...
Grouping and filtering in Power BI Copilot AI Instructions
Specify the columns returned in results and filters on rows
blog.crossjoin.co.uk
June 15, 2025 at 5:29 PM
Requiring selections on the Date dimension in #PowerBI Copilot with AI Instructions blog.crossjoin.co.uk/2025/06/08/r...
Requiring selections on the Date dimension in Power BI Copilot AI Instructions
Use AI Instructions to make sure a user always selects a date, month or year
blog.crossjoin.co.uk
June 8, 2025 at 8:39 PM