Chris Webb
@cwebbbi.bsky.social
📤 819
📥 235
📝 82
I work at Microsoft on the Fabric CAT team. Posts are my own.
#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 days ago
1
2
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/
10 days 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/
17 days 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/
24 days 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/
about 1 month 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/
about 1 month 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/
about 1 month 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/
about 2 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/
about 2 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/
2 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/
2 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/
3 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/
3 months ago
1
1
1
Useful community tools and resources for
#PowerBI
and
#MicrosoftFabric
blog.crossjoin.co.uk/2025/08/24/u...
3 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/
3 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/
4 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/
4 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/
4 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/
4 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/
5 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/
5 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/
5 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/
5 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!
5 months ago
0
6
0
Join the Fabric User Research Panel!
blog.crossjoin.co.uk/2025/06/17/j...
5 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/
5 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/
6 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/
6 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/
6 months ago
0
7
2
reposted by
Chris Webb
Kerry Kole
6 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/
6 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/
7 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/
7 months ago
0
8
1
reposted by
Chris Webb
Vahid Doustimajd
7 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
7 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/
7 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/
8 months ago
0
5
2
Using
#Excel
Copilot to import data with
#PowerQuery
blog.crossjoin.co.uk/2025/03/30/u...
8 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/
8 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/
8 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/
9 months ago
0
9
3
Another way to visualise Import model semantic model partition refresh parallelism in
#PowerBI
blog.crossjoin.co.uk/2025/03/02/a...
loading . . .
Another way to visualise Import model semantic model partition refresh parallelism
View refresh parallelism in one-second bins
https://blog.crossjoin.co.uk/2025/03/02/another-way-to-visualise-import-mode-semantic-model-partition-refresh-parallelism/
9 months ago
0
4
0
Monthly
#PowerBI
semantic model refreshes with Fabric Data Pipelines
blog.crossjoin.co.uk/2025/02/23/m...
loading . . .
Monthly Power BI semantic model refreshes with Fabric Data Pipelines
Refreshing with a Data Pipeline offers more flexibility with scheduling
https://blog.crossjoin.co.uk/2025/02/23/monthly-power-bi-semantic-model-refreshes-with-fabric-data-pipelines/
9 months ago
0
5
0
Reading Delta metadata in
#PowerQuery
blog.crossjoin.co.uk/2025/02/16/r...
#Fabric
loading . . .
Reading Delta metadata in Power Query
Use the DeltaLake.Metadata M function to read Delta metadata
https://blog.crossjoin.co.uk/2025/02/16/reading-delta-metadata-in-power-query/
9 months ago
1
4
0
reposted by
Chris Webb
Paul Andrew
10 months ago
This Wednesday, join us in
#Derby
for the monthly
#EastMidlandsData
#MeetUp
Special guest
@azureplayer.bsky.social
will be talking to us about
#MicrosoftFabric
SQL Databases.
www.meetup.com/eastmidlands...
loading . . .
12th Feb 25| East Midlands Data | Derby | Speaker - Kamil Nowinski, Wed, Feb 12, 2025, 6:00 PM | Meetup
**___________________________________________________________________________________** **MeetUp Agenda** 18:00 - Arrive. Networking 18:30 - Guest Speaker Talk 19:30 - Bu
https://www.meetup.com/eastmidlandsdata/events/305533278
0
2
2
Improve
#PowerQuery
performance on CSV files containing Date columns
blog.crossjoin.co.uk/2025/02/09/i...
loading . . .
Improve Power Query performance on CSV files containing Date columns
Using the DateFromText may be faster
https://blog.crossjoin.co.uk/2025/02/09/improve-power-query-performance-on-csv-files-containing-date-columns/
10 months ago
1
9
5
Limit the impact of expensive
#PowerBI
queries on your capacity by reducing the query timeout
blog.crossjoin.co.uk/2025/02/02/l...
loading . . .
Limit the impact of expensive Power BI queries on your capacity by reducing the query timeout
Slow queries often use a lot of CUs
https://blog.crossjoin.co.uk/2025/02/02/limit-the-impact-of-expensive-power-bi-queries-on-your-capacity-by-reducing-the-query-timeout/
10 months ago
1
13
4
Why DAX is better than MDX for bulk extracts of data from
#PowerBI
blog.crossjoin.co.uk/2025/01/26/w...
loading . . .
Why DAX is better than MDX for bulk extracts of data from Power BI
DAX queries are faster and more CPU and memory efficient
https://blog.crossjoin.co.uk/2025/01/26/why-dax-is-better-than-mdx-for-bulk-extracts-of-data-from-power-bi/
10 months ago
1
9
2
TMDL View and
#PowerBI
developer productivity
blog.crossjoin.co.uk/2025/01/19/t...
loading . . .
TMDL View and Power BI developer productivity
Example of how to set the Detail Rows Definition property of a measure in TMDL View
https://blog.crossjoin.co.uk/2025/01/19/tmdl-view-and-power-bi-developer-productivity-an-example-using-the-detail-rows-definition-property/
10 months ago
0
8
1
Changing the source Lakehouse of
#PowerBI
Direct Lake models in deployment pipelines
blog.crossjoin.co.uk/2025/01/12/c...
loading . . .
Changing the source Lakehouse of Power BI Direct Lake models in deployment pipelines
Use a data source rule to do this
https://blog.crossjoin.co.uk/2025/01/12/changing-the-source-lakehouse-of-power-bi-direct-lake-models-in-deployment-pipelines/
11 months ago
0
5
0
Load more
feeds!
log in
