Advertisement · 728 × 90

Posts by Chris Webb

Preview
Power BI semantic model refresh warnings Power BI now shows warnings about broken measures and other items in its refresh history

#PowerBI semantic model refresh warnings blog.crossjoin.co.uk/2026/04/19/p...

1 day ago 1 0 0 0
Post image

#PowerBI and support for third party semantic models blog.crossjoin.co.uk/2026/04/12/p...

1 week ago 2 0 1 0
Preview
Role-playing dimensions in Fabric Direct Lake semantic models revisited A workaround to allow you to create multiple tables in a Direct Lake semantic model linked to the same table in OneLake

Role-playing dimensions in Fabric Direct Lake semantic models revisited blog.crossjoin.co.uk/2026/04/05/r...

2 weeks ago 1 0 0 0
Preview
Generating Excel reports with Fabric Dataflows Gen2 Dataflows Gen2 can now generate Excel files with tables and charts

Generating Excel reports with Fabric Dataflows Gen2 blog.crossjoin.co.uk/2026/03/29/g...

3 weeks ago 5 2 0 0
Post image

Interested in attending the European Microsoft Fabric + SQL Community Conference?
Then book your ticket today to save €600!
📆 Sep 28 - 01 Oct 2026
📍CCIB, Barcelona, Spain
🎫 www.sharepointeurope.com/european-microsoft-fabri...
#MicrosoftFabric #MIcrosoftSQL

3 weeks ago 0 1 0 0
Preview
When can Partitioned Compute help improve Fabric Dataflow performance? Partitioned Compute lets you parallelise tasks inside a Dataflow

When can Partitioned Compute help Fabric Dataflow performance? blog.crossjoin.co.uk/2026/03/15/w...

1 month ago 1 2 0 0
Preview
Chris Webb's BI Blog: A Closer Look At Preview-Only Steps In Fabric Dataflows I have been spending a lot of time recently investigating the new performance-related features that have rolled out in Fabric Dataflows over the last few months, so expect a lot of blog posts on th…

A closer look at Preview-Only steps in Fabric Dataflows blog.crossjoin.co.uk/2026/03/08/a...

1 month ago 2 0 0 0
Preview
Power BI, parallelism and dependencies between SQL queries in DirectQuery mode How strict and eager evaluation can affect parallelism in DirectQuery mode

#PowerBI, parallelism and dependencies between SQL queries in DirectQuery mode blog.crossjoin.co.uk/2026/02/22/p...

1 month ago 0 0 0 0
Advertisement
Preview
Calculate, DAX fusion and filters on 0 in Power BI Filtering on 0 can be bad for performance if you're not careful

Calculate(), DAX fusion and filters on 0 in #PowerBI blog.crossjoin.co.uk/2026/01/25/c...

2 months ago 1 0 0 0
Preview
Measuring the time to display image visuals in Power BI with Performance Analyzer Large images can make reports slow

Measuring time to display for image visuals in #PowerBI with Performance Analyzer blog.crossjoin.co.uk/2026/01/18/m...

3 months ago 0 0 0 0
Preview
Measuring geocoding performance in Power BI map visuals using Performance Analyzer Geocoding could be making your report slow

Measuring geocoding performance in #PowerBI map visuals with Performance Analyzer blog.crossjoin.co.uk/2026/01/11/m...

3 months ago 4 0 1 0
Preview
Diagnosing Power BI DirectQuery performance problems caused by SQL queries that return large resultsets Large resultsets can be slow to read

Diagnosing #PowerBI DirectQuery performance problems caused by SQL queries that return large resultsets blog.crossjoin.co.uk/2026/01/04/d...

3 months ago 1 0 0 0
Preview
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

Diagnosing #PowerBI DirectQuery connection limit problems with Performance Analyzer blog.crossjoin.co.uk/2025/12/28/d...

3 months ago 1 0 0 0
Preview
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

Visualising #PowerBI Performance Analyzer data with a vibe-coded custom visual blog.crossjoin.co.uk/2025/12/21/v...

3 months ago 2 0 0 0
Preview
Power BI Copilot and report filters and slicers How report filters and slicers influence how Copilot answers questions

#PowerBI Copilot and report filters and slicers blog.crossjoin.co.uk/2025/12/14/p...

4 months ago 2 0 0 0
Advertisement
Preview
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

Stopping #PowerBI Copilot from answering questions from report visuals blog.crossjoin.co.uk/2025/12/07/s...

4 months ago 2 1 0 0
Preview
Impact of Calendar Based Time Intelligence on Power BI DirectQuery performance Significant performance improvements are possible but not in all cases

A look at the impact of calendar-based time intelligence on #PowerBI DirectQuery performance blog.crossjoin.co.uk/2025/11/30/a...

4 months ago 8 2 0 0

It might be a non-problem for you, but it’s a very real danger for lots of other people out there. But I’m not the PM in charge of apps so never say never…

4 months ago 1 0 1 0
Preview
Power BI, Build permissions and security Build permissions are not security!

#PowerBI Build permissions and security blog.crossjoin.co.uk/2025/11/23/p...

4 months ago 3 0 1 0

I suppose part of my job is to address the "Microsoft doesn't get us" problem - it's why I'm replying here! As for publish-to-web, I agree we probably wouldn't have built that (at least not in the same way) if we knew then what we know now. And because we know what we know now, we won't hide tabs.

5 months ago 1 0 1 0

So the next question will be - if you can already share thin reports which have this problem, why not allow hiding of tabs? To which I would answer: it would just lead to even more opportunities for misunderstanding how things work and accidental leaking of data, hence the reluctance.

5 months ago 1 0 2 0

Sharing thin reports is similar to hiding tabs - a lot of people assume that your users will only be able to see the data that is visible in the report, which is not the case (eg now people with Viewer access to a workspace can use the Explore feature)

5 months ago 0 0 1 0

No, I totally get how useful control over which tabs are visible would be. It's just that there are ways to see the data on those tabs even if they are hidden, so hiding a tab isn't secure. It's not about degrees of strictness, you're either secure or you aren't.

5 months ago 0 0 2 0

Oh, and security at the model level (granting/denying access to the model that is).

5 months ago 1 0 0 0
Advertisement

I've written a blog post on this that will be published on Sunday! Basically the semantic model is the security boundary, not the report. There are always ways to get around visibility settings; RLS and OLS are the only true security.

5 months ago 1 0 2 0

The trouble is that it couldn’t be made secure and while you might think that your users aren’t bothered about hacking pages they can’t see, if we did this there would immediately be complaints from customers who ignored the warnings and had users view data they should not have seen.

5 months ago 1 0 1 0
Preview
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

Linking queries run from DAX Studio to Workspace Monitoring and the Capacity Metrics app blog.crossjoin.co.uk/2025/11/16/l...

5 months ago 4 0 0 0
Preview
Calling DAX UDFs from Power BI Copilot An example showing how Copilot can call a DAX UDF that does ABC analysis

Calling DAX UDFs from #PowerBI Copilot blog.crossjoin.co.uk/2025/11/09/c...

5 months ago 2 0 0 0

I think everyone is reading wayyyy too much into someone at Microsoft moving to a new job

5 months ago 4 0 2 0
Preview
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

Monitoring the DAX queries generated when the #PowerBI Copilot index is built blog.crossjoin.co.uk/2025/11/02/m...

5 months ago 4 0 0 0