Chris Webb
@cwebbbi.bsky.social
📤 846
📥 388
📝 91
I work at Microsoft on the Fabric CAT team. Posts are my own.
Calculate(), DAX fusion and filters on 0 in
#PowerBI
blog.crossjoin.co.uk/2026/01/25/c...
loading . . .
Calculate, DAX fusion and filters on 0 in Power BI
Filtering on 0 can be bad for performance if you're not careful
https://blog.crossjoin.co.uk/2026/01/25/calculate-dax-fusion-and-filters-on-0-in-power-bi/
27 days ago
0
1
0
Measuring time to display for image visuals in
#PowerBI
with Performance Analyzer
blog.crossjoin.co.uk/2026/01/18/m...
loading . . .
Measuring the time to display image visuals in Power BI with Performance Analyzer
Large images can make reports slow
https://blog.crossjoin.co.uk/2026/01/18/measuring-time-to-display-for-image-visuals-in-power-bi-with-performance-analyzer/
about 1 month ago
0
0
0
Measuring geocoding performance in
#PowerBI
map visuals with Performance Analyzer
blog.crossjoin.co.uk/2026/01/11/m...
loading . . .
Measuring geocoding performance in Power BI map visuals using Performance Analyzer
Geocoding could be making your report slow
https://blog.crossjoin.co.uk/2026/01/11/measuring-geocoding-performance-in-power-bi-map-visuals-using-performance-analyzer/
about 1 month ago
1
4
0
Diagnosing
#PowerBI
DirectQuery performance problems caused by SQL queries that return large resultsets
blog.crossjoin.co.uk/2026/01/04/d...
loading . . .
Diagnosing Power BI DirectQuery performance problems caused by SQL queries that return large resultsets
Large resultsets can be slow to read
https://blog.crossjoin.co.uk/2026/01/04/diagnosing-power-bi-directquery-performance-problems-caused-by-sql-queries-that-return-large-resultsets/
about 2 months ago
0
1
0
Diagnosing
#PowerBI
DirectQuery connection limit problems with Performance Analyzer
blog.crossjoin.co.uk/2025/12/28/d...
loading . . .
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
https://blog.crossjoin.co.uk/2025/12/28/diagnosing-power-bi-directquery-connection-limit-problems-with-performance-analyzer/
about 2 months ago
0
1
0
Visualising
#PowerBI
Performance Analyzer data with a vibe-coded custom visual
blog.crossjoin.co.uk/2025/12/21/v...
loading . . .
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
https://blog.crossjoin.co.uk/2025/12/21/visualising-power-bi-performance-analyzer-data-with-a-vibe-coded-custom-visual/
2 months ago
0
2
0
#PowerBI
Copilot and report filters and slicers
blog.crossjoin.co.uk/2025/12/14/p...
loading . . .
Power BI Copilot and report filters and slicers
How report filters and slicers influence how Copilot answers questions
https://blog.crossjoin.co.uk/2025/12/14/power-bi-copilot-and-report-filters-and-slicers/
2 months ago
0
2
0
Stopping
#PowerBI
Copilot from answering questions from report visuals
blog.crossjoin.co.uk/2025/12/07/s...
loading . . .
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
https://blog.crossjoin.co.uk/2025/12/07/stopping-power-bi-copilot-from-answering-questions-from-report-visuals/
3 months ago
0
2
2
A look at the impact of calendar-based time intelligence on
#PowerBI
DirectQuery performance
blog.crossjoin.co.uk/2025/11/30/a...
loading . . .
Impact of Calendar Based Time Intelligence on Power BI DirectQuery performance
Significant performance improvements are possible but not in all cases
https://blog.crossjoin.co.uk/2025/11/30/a-look-at-the-impact-of-calendar-based-time-intelligence-on-power-bi-directquery-performance/
3 months ago
0
8
2
#PowerBI
Build permissions and security
blog.crossjoin.co.uk/2025/11/23/p...
loading . . .
Power BI, Build permissions and security
Build permissions are not security!
https://blog.crossjoin.co.uk/2025/11/23/power-bi-build-permissions-and-security/
3 months ago
1
3
0
Linking queries run from DAX Studio to Workspace Monitoring and the Capacity Metrics app
blog.crossjoin.co.uk/2025/11/16/l...
loading . . .
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
https://blog.crossjoin.co.uk/2025/11/16/linking-queries-run-from-dax-studio-to-workspace-monitoring-and-the-capacity-metrics-app/
3 months ago
0
4
0
Calling DAX UDFs from
#PowerBI
Copilot
blog.crossjoin.co.uk/2025/11/09/c...
loading . . .
Calling DAX UDFs from Power BI Copilot
An example showing how Copilot can call a DAX UDF that does ABC analysis
https://blog.crossjoin.co.uk/2025/11/09/calling-dax-udfs-from-power-bi-copilot/
3 months ago
0
2
0
Monitoring the DAX queries generated when the
#PowerBI
Copilot index is built
blog.crossjoin.co.uk/2025/11/02/m...
loading . . .
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
https://blog.crossjoin.co.uk/2025/11/02/monitoring-the-dax-queries-generated-when-the-power-bi-copilot-index-is-built/
4 months ago
0
4
0
Understanding the “Copilot analyzed only part of this model due to its size” warning in
#PowerBI
blog.crossjoin.co.uk/2025/10/26/u...
loading . . .
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
https://blog.crossjoin.co.uk/2025/10/26/understanding-the-copilot-analyzed-only-part-of-the-model-due-to-its-size-warning-in-power-bi-copilot/
4 months ago
0
0
0
Monitor Fabric costs with Fabric Cost Analysis
blog.crossjoin.co.uk/2025/10/19/m...
loading . . .
Monitor Fabric costs with Fabric Cost Analysis
It's a solution built using Fabric for monitoring Fabric costs
https://blog.crossjoin.co.uk/2025/10/19/monitor-fabric-costs-with-fabric-cost-analysis/
4 months ago
0
4
0
First look at Fabric Graph: Analysing
#PowerBI
Import mode refresh job graphs
blog.crossjoin.co.uk/2025/10/12/f...
loading . . .
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
https://blog.crossjoin.co.uk/2025/10/12/first-look-at-fabric-graph-analysing-power-bi-import-mode-refresh-job-graphs/
4 months ago
0
3
0
Snowflake query tags in
#PowerBI
and Workspace Monitoring
blog.crossjoin.co.uk/2025/10/05/s...
loading . . .
Snowflake query tags in Power BI and Workspace Monitoring
Link a Snowflake query to the Power BI operation that generated it
https://blog.crossjoin.co.uk/2025/10/05/snowflake-query-tags-in-power-bi-and-workspace-monitoring/
5 months ago
0
3
0
Linking Fabric Warehouse SQL queries and Spark jobs to the Capacity Metrics App
blog.crossjoin.co.uk/2025/09/28/l...
loading . . .
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
https://blog.crossjoin.co.uk/2025/09/28/linking-fabric-warehouse-sql-queries-and-spark-jobs-to-the-capacity-metrics-app/
5 months ago
0
1
0
Finding
#PowerBI
queries and refreshes that have been throttled using Workspace Monitoring
blog.crossjoin.co.uk/2025/09/21/f...
loading . . .
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
https://blog.crossjoin.co.uk/2025/09/21/finding-power-bi-queries-and-refreshes-that-have-been-throttled-with-workspace-monitoring/
5 months ago
0
3
0
How to get the details of
#PowerBI
operations seen in the Capacity Metrics App
blog.crossjoin.co.uk/2025/09/14/h...
loading . . .
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
https://blog.crossjoin.co.uk/2025/09/14/how-to-get-the-details-of-power-bi-operations-seen-in-the-capacity-metrics-app/
5 months ago
0
6
0
What happens when
#PowerBI
Direct Lake models hit guardrails?
blog.crossjoin.co.uk/2025/09/07/w...
loading . . .
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
https://blog.crossjoin.co.uk/2025/09/07/what-happens-when-power-bi-direct-lake-semantic-models-hit-guardrails/
6 months ago
0
2
0
Performance testing
#PowerBI
Direct Lake models revisited: ensuring worst-case performance
blog.crossjoin.co.uk/2025/08/31/p...
loading . . .
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
https://blog.crossjoin.co.uk/2025/08/31/performance-testing-power-bi-direct-lake-models-revisited-ensuring-worst-case-performance/
6 months ago
1
1
1
Useful community tools and resources for
#PowerBI
and
#MicrosoftFabric
blog.crossjoin.co.uk/2025/08/24/u...
6 months ago
0
2
0
#PowerBI
Copilot, AI Instructions and DAX query templates
blog.crossjoin.co.uk/2025/08/17/p...
loading . . .
https://blog.crossjoin.co.uk/2025/08/17/power-bi-copilot-ai-instructions-and-dax-query-templates/
6 months ago
0
3
0
#PowerBI
Copilot, AI Instructions and DAX measure definitions
blog.crossjoin.co.uk/2025/08/10/p...
loading . . .
Power BI Copilot, AI Instructions and DAX measure definitions
Adding measure definitions to Copilot AI Instructions helps users understand how measures work
https://blog.crossjoin.co.uk/2025/08/10/power-bi-copilot-ai-instructions-and-dax-measure-definitions/
6 months ago
1
3
0
Why do
#PowerBI
Copilot AI Instructions seem to work better in Desktop than in the Service?
blog.crossjoin.co.uk/2025/08/03/w...
loading . . .
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
https://blog.crossjoin.co.uk/2025/08/03/why-do-power-bi-copilot-ai-instructions-seem-to-work-better-in-desktop-than-in-the-service/
7 months ago
1
2
0
#PowerBI
Copilot, AI Instructions and visualisation guidelines
blog.crossjoin.co.uk/2025/07/27/p...
loading . . .
Power BI Copilot, AI Instructions and visualisation guidelines
Control which visuals Copilot uses in responses
https://blog.crossjoin.co.uk/2025/07/27/power-bi-copilot-ai-instructions-and-visualisation-guidelines/
7 months ago
0
3
0
#PowerBI
Copilot, AI Instructions and semantic model relationships
blog.crossjoin.co.uk/2025/07/20/p...
loading . . .
Power BI Copilot, AI Instructions and semantic model relationships
Learn how Copilot works with measures and columns on different tables
https://blog.crossjoin.co.uk/2025/07/20/power-bi-copilot-ai-instructions-and-semantic-model-relationships/
7 months ago
0
1
0
#PowerBI
Copilot, AI Instructions and dealing with ambiguity
blog.crossjoin.co.uk/2025/07/13/p...
loading . . .
Power BI Copilot, AI Instructions and dealing with ambiguity
Make Copilot ask for clarification instead of guessing so often
https://blog.crossjoin.co.uk/2025/07/13/power-bi-copilot-ai-instructions-and-dealing-with-ambiguity/
7 months ago
0
3
0
#PowerBI
Copilot, AI Instructions and preventing the use of implicit measures
blog.crossjoin.co.uk/2025/07/06/p...
loading . . .
Power BI Copilot, AI Instructions and preventing the use of implicit measures
Stop Copilot from aggregating data itself
https://blog.crossjoin.co.uk/2025/07/06/power-bi-copilot-ai-instructions-and-preventing-the-use-of-implicit-measures/
8 months ago
0
3
0
Data validation in
#PowerBI
Copilot AI Instructions
blog.crossjoin.co.uk/2025/06/29/d...
loading . . .
Data validation in Power BI Copilot AI Instructions
Helping users enter valid values for filters in their prompt can improve the Copilot user experience
https://blog.crossjoin.co.uk/2025/06/29/data-validation-in-power-bi-copilot-ai-instructions/
8 months ago
1
3
0
#PowerBI
Copilot AI Instructions: helping users understand the scope of the data
blog.crossjoin.co.uk/2025/06/22/p...
loading . . .
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
https://blog.crossjoin.co.uk/2025/06/22/power-bi-copilot-ai-instructions-helping-users-understand-the-scope-of-the-data/
8 months ago
0
4
0
Had an amazing time at
#SQLBits
as always. Many thanks to the organisers, helpers, speakers, sponsors and of course the attendees!
8 months ago
0
6
0
Join the Fabric User Research Panel!
blog.crossjoin.co.uk/2025/06/17/j...
8 months ago
0
1
0
Grouping and filtering in
#PowerBI
Copilot AI Instructions
blog.crossjoin.co.uk/2025/06/15/g...
loading . . .
Grouping and filtering in Power BI Copilot AI Instructions
Specify the columns returned in results and filters on rows
https://blog.crossjoin.co.uk/2025/06/15/grouping-and-filtering-in-power-bi-copilot-ai-instructions/
8 months ago
0
0
0
Requiring selections on the Date dimension in
#PowerBI
Copilot with AI Instructions
blog.crossjoin.co.uk/2025/06/08/r...
loading . . .
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
https://blog.crossjoin.co.uk/2025/06/08/requiring-selections-on-the-date-dimension-in-power-bi-copilot-ai-instructions/
9 months ago
0
1
1
Finding reports and semantic models easily with
#PowerBI
Copilot Search
blog.crossjoin.co.uk/2025/06/01/f...
loading . . .
Finding reports and semantic models easily with Power BI Copilot Search
The new Copilot Search feature works better than Power BI's existing search
https://blog.crossjoin.co.uk/2025/06/01/finding-reports-and-semantic-models-easily-with-power-bi-copilot-search/
9 months ago
0
3
0
Generating sample data with Copilot in
#MicrosoftFabric
Dataflows Gen2
blog.crossjoin.co.uk/2025/05/25/g...
loading . . .
Generating sample data with Copilot in Fabric Dataflows Gen2
Use Copilot to generate tables of sample data
https://blog.crossjoin.co.uk/2025/05/25/generating-sample-data-with-copilot-in-fabric-dataflows-gen2/
9 months ago
0
7
2
reposted by
Chris Webb
Kerry Kole
9 months ago
blogged. A How-To For Power BI - ers.
#PowerBI
kerrykolosko.com/timeseries-s...
loading . . .
Timeseries smoothing - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Quite often when exploring data within Power BI, we might want to visualise timeseries data, only to be met with an unsightly jagged line: We might be tempted to smooth it by changing to weekly or mon...
https://kerrykolosko.com/timeseries-smoothing/
0
9
3
Performance implications of different ways of fully expanding a
#PowerBI
matrix visual
blog.crossjoin.co.uk/2025/05/18/p...
loading . . .
Performance implications of different ways of fully expanding a Power BI matrix visual
Using "expand to next level" can improve performance
https://blog.crossjoin.co.uk/2025/05/18/performance-implications-of-different-ways-of-fully-expanding-a-power-bi-matrix-visual/
9 months ago
0
3
0
Finding events linked to a specific
#PowerBI
visual in Fabric Workspace Monitoring
blog.crossjoin.co.uk/2025/05/11/f...
loading . . .
Finding events linked to a specific Power BI visual in Fabric Workspace Monitoring
Use ID from the "Copy Object Name" feature to filter events
https://blog.crossjoin.co.uk/2025/05/11/finding-events-linked-to-a-specific-power-bi-visual-in-fabric-workspace-monitoring/
10 months ago
0
3
1
Documenting
#PowerBI
semantic models with Fabric Data Agents
blog.crossjoin.co.uk/2025/05/04/d...
loading . . .
Documenting Power BI semantic models with Fabric Data Agents
Use Data Agents to generate documentation and understand the dependencies between DAX calculations
https://blog.crossjoin.co.uk/2025/05/04/documenting-power-bi-semantic-models-with-fabric-data-agents/
10 months ago
0
8
1
reposted by
Chris Webb
Vahid Doustimajd
10 months ago
𝗖𝘂𝗿𝗶𝗼𝘂𝘀 𝗵𝗼𝘄 𝗔𝗜 𝗶𝘀 𝘁𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜? Join us for a Power BI Copilot Deep Dive session where we explore how AI is reshaping data and analytics inside Power BI. Speaker:
@cwebbbi.bsky.social
Link:
lnkd.in/gbXWfT2p
loading . . .
Power BI Copilot Deep Dive | LinkedIn
Everyone is excited about AI and the impact it can have on data and analytics, and in Power BI that promise is being delivered on with Copilot. In this session you'll learn everything you need to know...
https://lnkd.in/gbXWfT2p
0
2
1
reposted by
Chris Webb
Aysha Hamisi
10 months ago
I wrote a blog about semantic model refresh options in
#Fabric
#powerbi
, please read and share!
www.advancinganalytics.co.uk/blog/semanti...
loading . . .
Semantic Model Refresh in Fabric: Beyond the Defaults
Optimise Power BI semantic models with advanced refresh options in Fabric, utilising data pipelines and semantic link for enhanced control and efficiency.
https://www.advancinganalytics.co.uk/blog/semantic-model-refresh-in-fabric?utm_campaign=8745845-Data%20Analytics%20-%202025&utm_content=331879072&utm_medium=social&utm_source=linkedin&hss_channel=lcp-12986209
0
4
3
Two new
#PowerBI
/
#PowerQuery
books
blog.crossjoin.co.uk/2025/04/27/t...
loading . . .
Two new Power BI/Power Query books
Book reviews for "Power Query beyong the user interface" and "Architecting Power BI Solutions in Fabric"
https://blog.crossjoin.co.uk/2025/04/27/two-new-power-bi-power-query-books/
10 months ago
0
1
0
Fabric Data Agents: Unlocking the full power of DAX for data analysis
blog.crossjoin.co.uk/2025/04/06/f...
loading . . .
Fabric Data Agents: Unlicking the full power of DAX for data analysis
Data Agents let analysts solve complex problems more quickly
https://blog.crossjoin.co.uk/2025/04/06/fabric-data-agents-unlocking-the-full-power-of-dax-for-data-analysis/
11 months ago
0
5
2
Using
#Excel
Copilot to import data with
#PowerQuery
blog.crossjoin.co.uk/2025/03/30/u...
11 months ago
0
0
0
Speed up dataflow publishing/validation times in
#PowerBI
and
#MicrosoftFabric
blog.crossjoin.co.uk/2025/03/23/s...
loading . . .
Speed up dataflow publishing/validation times in #PowerBI and #MicrosoftFabric
How to get your dataflows to publish or validate immediately
https://blog.crossjoin.co.uk/2025/03/23/speed-up-dataflow-publishing-validation-times-in-power-bi-and-fabric/
11 months ago
0
0
0
Using
#Excel
Solver with
#PowerPivot
blog.crossjoin.co.uk/2025/03/16/u...
loading . . .
Using Excel Solver with Power Pivot
How to slice data with Solver
https://blog.crossjoin.co.uk/2025/03/16/using-excel-solver-with-power-pivot/
11 months ago
0
5
3
Refreshing hidden tables in
#PowerBI
semantic models with Fabric Data Pipelines
blog.crossjoin.co.uk/2025/03/09/r...
loading . . .
Refreshing hidden tables in Power BI semantic models with Fabric Data Pipelines
Use an expression to define which tables and partitions to refresh
https://blog.crossjoin.co.uk/2025/03/09/refreshing-hidden-tables-in-power-bi-semantic-models-with-fabric-data-pipelines/
12 months ago
0
9
3
Load more
feeds!
log in
