r/MicrosoftFabric • • 1h ago

Data Engineering New notebook cell info

4 Upvotes

I noticed the new notebook layout is now active. When I scroll down, the cell header stays visible, so I can run the cell without going back to the top of it. I like that!

I’m less happy that markdown cells now have a frame around them. I use markdown cells as section headers and navigate with the Table of Contents. Is it possible to remove the frame and the header from markdown cells?

The cell header shows “1:”, “2:”, and so on. Is it possible to give a cell its own title, so it shows something like “2: Setup”? If so, would that title also appear in the Table of Contents?


r/MicrosoftFabric • • 5h ago

Data Factory Airflow and session tags

2 Upvotes

Airflow + Microsoft Fabric: Missing session tag support
Hi everyone!
I’m currently running into a scalability issue when orchestrating Microsoft Fabric notebooks through Airflow.
The Microsoft Fabric Airflow provider does not appear to support session tags for job_type=RunNotebook.
As a result, every notebook execution starts its own Spark session instead of reusing an existing session. With a large number of notebooks, this means we’re repeatedly paying the Spark startup overhead, significantly impacting execution time and resource efficiency.
I’ve looked into the underlying Fabric API endpoints used by the provider, and they don’t appear to expose session tag support either.

Session tag support would be a highly valuable feature, particularly for workloads with high notebook concurrency. Without it, scaling Airflow and notebook orchestration in Fabric becomes unnecessarily expensive and inefficient….

One workaround I’ve considered is:
Create a separate Fabric pipeline for each notebook.
Pass parameters to the pipeline.
Configure the session tag through the pipeline’s advanced settings…(given by a simple parameter)
However, this feels like an unnecessarily complex and costly workaround for something that should ideally be supported directly when triggering a notebook.

Has anyone encountered this issue?
Am I missing something, or is there currently no way to reuse Spark sessions when triggering Fabric notebooks through Airflow?
Would love to hear how others are handling this. Perhaps there’s a better approach I’m overlooking!?!? :-)


r/MicrosoftFabric • • 5h ago

Power BI Unable to create/edit Direct Lake semantic model when source tables have OneLake Security RLS

3 Upvotes

Hi,

I believe I've found a reproducible issue involving OneLake Security RLS and Direct Lake semantic models.

SetUp

  • Source is a schema-enabled Lakehouse in a separate workspace A
  • Semantic model is Direct Lake on OneLake created by a user with workspace contributor role (of workspace B)
  • OneLake Security is enabled
  • The affected tables have Row-Level Security (RLS)
  • No Object-Level Security (OLS) is configured

Behaviour observed

I can create and edit a Direct Lake semantic model normally when the source tables aren't subject to OneLake Security RLS.

However, when the semantic model includes a table where OneLake Security RLS applies to the user, I'm unable to create/edit the semantic model.

If the RLS-protected table/access is removed, semantic model authoring works again.

So far, the behaviour appears specifically related to including OneLake Security RLS-protected tables from a schema-enabled Lakehouse in the Direct Lake semantic model.

Expected behaviour

My expectation is that a user with the appropriate permissions to create/edit the semantic model should still be able to:

  1. Create or edit a Direct Lake semantic model.
  2. Include tables protected by OneLake Security RLS.
  3. Edit the semantic model normally.
  4. Have OneLake Security RLS applied when data is accessed using the relevant user identity.

In other words, I would expect RLS to control which rows the user can access, rather than prevent the table from being used during semantic model authoring.

Actual behaviour

Once a table protected by OneLake Security RLS is included, semantic model creation/editing fails.

The same scenario works when the RLS condition is not applied (e.g. unrestricted role)

To clarify, there is no OLS involved in this test, only RLS.

Question

Has anyone else encountered this behaviour?

Is there a known limitation where Direct Lake semantic model authoring cannot work with an RLS-protected table when using OneLake Security, particularly with a schema-enabled Lakehouse?

Or is this potentially a bug in the current Direct Lake / OneLake Security implementation?

Thanks.


r/MicrosoftFabric • • 11h ago

Data Engineering How do you handle rows that fail a check today but will pass later (reference data not there yet)?

6 Upvotes

I have a daily batch, PySpark + Delta, medallion.

Some of my rows fail a check when I build a table, but they are not wrong. The reference data they need is just not there yet, and a couple of days later the same row would pass. So I have to keep them somewhere and retry them on every run.

How do you handle this?

- Where do the failed rows live?

- What exactly do you store for them?

- How do they get retried?

Is there a known pattern for this?


r/MicrosoftFabric • • 12h ago

Data Factory No failure bodies from Web.Contents in PQ?

4 Upvotes

Can anyone tell me what they do to troubleshoot API failures?

Consider a web connector operation like this:

let
    BaseUrl = "https://example.com",
    Response = Web.Contents(
        BaseUrl,
        [
            RelativePath = "/v1/items",....
        ]
    ),
    JsonData = Json.Document(Response)
in
    JsonData

... if this fails with 500 code or whatever, the reason phrase from HTTP may say nothing more than "internal failure". This is the thing that is prominently exposed in the Power BI logs and UX.

However this is a meaningless message. For most REST APIs there should also be a response body that has a full stack trace and other contextual messages.

However when I look in the gateway logs I can't find the HTTP response body for failures. I don't think it is presented even when enhanced diagnostics are enabled. What are PQ developers supposed to do for troubleshooting web connectors that fail intermittently? I have not found a good approach, either in prod or in dev. (It doesn't help matters that Fiddler recently stopped being "free forever". But even when Fiddler was free, it wasn't a great way to debug our PQ.)


r/MicrosoftFabric • • 13h ago

Power BI Report Usage Metrics deleted by Microsoft?

Post image
7 Upvotes

Did anyone else experience that your usage metrics in the "new" usage metrics report are cut off like 3 days ago? We see only data for the last three days, while in the old usage metrics we see more realistic data for the last three months showing usage every day. Although this alone is already a strong indicator that there is a bug on #Microsoft side, I also double-checked whether someone deleted a report and created a new one with a new ID starting new usage metrics tracking, but this report ID has existed for months. For one case I even deleted the semantic model of this new usage metrics report so it was recreated on next new usage metrics report open, but it still shows only this data.
Is there any way to fix this? Or is this just yet another glitch in a long history of glitches on this toy data platform?


r/MicrosoftFabric • • 15h ago

App Development Fabricator App Deployment - Change DB connections between environments

7 Upvotes

We have developed a simple MDM app using Fabricator that points to an existing SQL DB in a DEV workspace.

We now want to deploy this into a Production workspace and when we do it, the app should point to the SQL DB in the Production workspace.

When we publish the app to the Production workspace using Fabricator, it still points to the DEV DB.

If we publish using Deployment pipelines too, it continues to point to the DEV DB.

The only option I've found so far is to change the connection in the local Fabricator environment first to point to the Production DB and then deploy it into the PROD workspace but that seems like a risky process prone to mistakes.

Does a better process exist?


r/MicrosoftFabric • • 16h ago

Community Share I always explain Fabric to customers as a building with apartments, so I built the 3D version

22 Upvotes

I always explain Fabric to customers as a building with apartments, so I built the 3D version

Whenever I explain Fabric to customers, I end up saying it's like a building with apartments: everyone has their own space, but they share the same compute and utilities. It works pretty well, people get it right away.

So I wanted to see how far I could push that idea, and turned it into an actual 3D map built on FUAM data. Domains are towns, workspaces are houses, capacities are the power plants feeding them. If a domain has failures, there's a storm over that town, and you can fly down to a house and walk inside to see what's in there and who has keys.

Honestly, I did it because it was fun and fast to build. But it turned out to be a nice way to look at a tenant too.

GIFs and details are in the Fabric Apps Gallery (all fake Contoso data).


r/MicrosoftFabric • • 16h ago

Community Share Fabric Update - November 17th, 2026

Thumbnail
youtu.be
19 Upvotes

r/MicrosoftFabric • • 18h ago

Discussion Fabric Down? Anyone else?

12 Upvotes

We are in the US. Today around 10 eastern I am just now noticing semantic models not loading and other users are saying some reports are not loading and someone else mentioned query against the warehouse is not running. Nothing is reporting on Microsoft system outage. Does not seem to be capacity issue. Anyone else experiencing problems today?


r/MicrosoftFabric • • 19h ago

Data Factory Browse SharePoint: the new easiest way to connect to any files or folders in SharePoint!

Post image
29 Upvotes

You start with a list of all the SharePoint sites that you have access and you can navigate through any of them like you would in a file explorer and then connect to either a file or a specific folder (with a chance to exclude subfolders).

Have you given this a try? Currently available in Dataflow Gen2 for Fabric.

Documentation article: https://learn.microsoft.com/power-query/get-data-sharepoint


r/MicrosoftFabric • • 19h ago

Administration & Governance What criteria do you use to certify items in Fabric (vs. just Promoted)?

4 Upvotes

Hi all,

We’re rolling out endorsement in our Fabric tenant and I’m trying to define a sensible certification process. Promoted feels straightforward: the owner decides it’s ready to share and flags it. But I’m struggling with what should be required for Certified.

I’d love to hear how others handle this:

  1. What are your must-have criteria before an item gets the Certified badge?
  2. Do you use different standards for different item types (semantic models vs. lakehouses vs. reports)?

r/MicrosoftFabric • • 19h ago

Discussion New folders in Lakehouse?

4 Upvotes

Just saw 2 new folder in the lakehouse view, didn't read anything about this in the November Feature summary?


r/MicrosoftFabric • • 20h ago

Administration & Governance New table overview pane with descriptions

9 Upvotes

When you open a table in a lakehouse, you now can see an overview with a summary and column overview just like Databricks has. What I don't get is where you can define the description of the table and columns. I tested the COMMENT in my sparksql query but that doesn't sync. Only entering a text using that new overview works.

The COMMENT data I entered in sparksql does show up in a new folder 'metadata' in the file view.

Is anyone else also testing this and did I miss something maybe?

New overview pane of a table
SparkSQL table definition using COMMENT
metadata folder with column COMMENT but no table COMMENT

r/MicrosoftFabric • • 20h ago

Security Workspace private link + Lakehouse with schemas: really not supported? Any ETA?

4 Upvotes

Hi all,

I'm designing a workspace setup with inbound public access denied (workspace private link), outbound access protection and CMK. The Security feature availability matrix lists:

ItemWorkspace private linksCMKOAP
Lakehouse✓✓✓
Lakehouse with Schema–✓✓

So schema-enabled lakehouses don't support workspace private link. But the workspace private link support page just says "Lakehouse" and doesn't mention schemas at all.

A few questions:

  1. Is this still accurate? Has anyone run a schema-enabled lakehouse in a workspace with inbound public access denied?
  2. If it isn't supported, what happens in practice? Does it block setting inbound to Deny (InboundRestrictionNotEligible)? Can you create the lakehouse at all? Or does it work and just isn't officially supported?
  3. Is there an ETA or roadmap item for support?

This matters for us because new lakehouses default to schemas, and our engineering workspace needs to be locked down.

Thanks!


r/MicrosoftFabric • • 21h ago

App Development Fabric Apps - Does it support "Apps-Owns-Data" embed?

9 Upvotes

We currently expose Power BI dashboards to users via a Custom Portal using App-Owns-Data method and users have no direct access to Fabric workspace.

We were eagerly waiting for the Fabric Apps GA announcement so we could start leveraging Fabric Apps for a multitude of use cases and also for some reports/dashboards given the level of flexibility it offers.

What's unclear though is whether Fabric apps can be embedded like regular power bi reports or not? If not, will it ever be supported or is it supposed to work only with Microsoft Entra always?


r/MicrosoftFabric • • 1d ago

Community Share Cross-workspaces workload: Experiment orchestrating one DAG across 50 and 500 Microsoft Fabric workspaces

9 Upvotes

Hey everyone,

I want to share an experiment I ran on cross-workspace orchestration across 50 and 500 Microsoft Fabric workspaces.

My motivation comes from my background running enterprise analytics for a large organisation. One of the distinctive strengths of Fabric, compared with other platforms, is its suitability for self-service BI across a large organisation. OneLake is pivotal to that.

This raises some common challenges I've experienced. If a central team manages shared data, while dozens of business teams independently build their own data products, how do we coordinate dependencies, understand the impact of failures and manage recovery?

So I set up an experiment with 50 workspaces, then scaled it to 500 to see whether the approach would hold.

In particular, I wanted to see whether Weaver, an open-source data engineering framework I've been building for Fabric, could handle the challenge.

The setup

I created 50 real Fabric workspaces on an FTL64 capacity:

  • 3 central workspaces covering Bronze, Silver, Gold and shared semantic models.
  • 47 business workspaces, each with its own catalogue.
  • A mixture of Lakehouses, Warehouses, semantic models and reports.
  • 53 cross-workspace connections, including a deliberate dependency cycle.

Every workspace was independently initialised, built and loaded. Together, they formed one dependency graph across the organisation.

I then deliberately broke a central Bronze customer table, BRZ.Customer.

The results

1. Enterprise-wide impact analysis

  • 161 downstream objects identified across 49 other catalogues.
  • Full assessment in 134 seconds.
  • The assessment distinguished stale objects from those still operational.

2. The central team could recover its own estate independently.

I then tested recovery from the central team's perspective, across its three workspaces.

A single load --stale identified and planned just six affected objects, in dependency order:

  • Bronze workspace: Reload the affected central Bronze data.
  • Silver/Gold workspace: Propagate the repair through the Silver Lakehouse and Gold Warehouse.
  • Semantic model workspace: Refresh the central semantic model against the repaired data.

The central team recovered its own estate without reloading any business team's data.

There was even a network interruption during the semantic model's load recording. On rerun, only the semantic model needed refreshing rather than repeating the entire recovery.

3. Business teams could see what was affected on their side.

I tested this from the perspective of business team 05.

  • Its own Health assessment identified two affected Mart tables.
  • It traced the cause back to BRZ.Customer.
  • The assessment took just 10 seconds.

No need to contact the central engineering team.

4. Business teams could decide how to recover.

After the central team repaired its estate, team 05 could see that its own tables were now behind the upstream data.

It reloaded only its two stale tables, taking 24 seconds, and returned to green.

No need to rebuild the whole workspace or wait for a central orchestrator.

5. The system tolerated dependency cycles.

I deliberately created a cycle between two business workspaces.

The cycle was identified and reported, and execution proceeded by cutting one dependency edge. The rest of the estate continued operating normally.

One object remained correctly stale afterwards because it had consumed the other team's previous load.

One final experiment

I also tried running one federated load across all 50 workspaces, with independent branches executing concurrently while respecting dependencies.

The result:

  • 81 execution nodes across 47 segments.
  • All successful under one workflow ID.
  • End-to-end time of 9 minutes 21 seconds.

This opens up another possibility: a central team could coordinate an organisation-wide refresh when required, while ordinary day-to-day execution remains decentralised.

Then I tried 500 workspaces.

I expanded the experiment to 500 workspaces: three central workspaces and 497 business teams, using the same FTL64 capacity.

The results:

  • 1,160 execution steps successfully coordinated in approximately 39 minutes.
  • 752 downstream objects traced to a single failure, spanning 450 workspaces.
  • Full Health assessment across 500 catalogues in approximately 5–7 minutes.
  • Individual team assessment still took around 13 seconds.

What I learned

OneLake is absolutely wonderful, and I think the Microsoft Fabric architecture is extremely strong for large enterprises.

With Fabric, teams can achieve two things:

  • Complete decentralised freedom when appropriate: Teams can own their workspaces, choose their tools and development processes, and use a common data hub.
  • Complete coordination when required: Dependencies, failure impacts, execution and recovery can be understood across the entire organisation.

My conclusion is that:

  • Microsoft Fabric is one of the strongest platforms for enterprise data analytics, where central information can be shared across multiple business areas without pigeonholing people into high-code development. People can choose Python, SQL, semantic models or simply reports. OneLake is a brilliant architectural foundation for this.
  • Open-source tools like Weaver can help data teams get the most out of Fabric. Not just with coordination challenges like this, but by giving teams a head start on robust data engineering across Python, Spark and T-SQL. And the more teams use it in an organisation, the better it gets.

I suspect I'm not alone in facing these challenges. Keen to hear about other people's experiences and techniques for managing multiple workspaces.

Do you have cross-workspace or cross-item dependency workloads? How do you deal with them?

Full experiment and technical details:

https://weaverstack.dev/guides/organising-microsoft-fabric-workspaces/

Happy to answer any questions!


r/MicrosoftFabric • • 1d ago

Power BI Rayfin Apps in Power BI Desktop

12 Upvotes

Hi all,

First of all, exciting news in Microsoft Ignite with the announcement of GA of Fabric Apps + the ability to create them from the Power BI Desktop.

Anyone knows how the "Copilot" part will be billed that you will use in the desktop? I can't find any documentation on this. Will it be your own license, or will it be charged to the Fabric Capacity ?

Thanks !


r/MicrosoftFabric • • 1d ago

Administration & Governance Have semantic model refreshes become cheaper?

7 Upvotes

Maybe I'm going crazy, but it looks like semantic model refresh operations became cheaper around 13th November?

Looks like our weekend load (yellow) and weekday load (orange) both fell by ~20%.

Anyone else experienced this?

CU(s) per day for semantic model activty

r/MicrosoftFabric • • 1d ago

App Development Fabric apps URL

5 Upvotes

Can we customise the URL of fabric apps based on our use case?


r/MicrosoftFabric • • 1d ago

App Development Fabric Apps to PBI Pro - Timing

8 Upvotes

At Fabricon, the announcement came that Fabric Apps were coming to those on PBI Pro licenses "in the coming weeks". Seven weeks later, at Ignite today, same message: "in the coming weeks".

At our tiny PBI Pro shop we're kinda halting PBI development right now for things that Fabric Apps are looking promising for, but I'm not enjoying this limbo phase.

I know we can "just upgrade to capacity" but it'll be a hard sell, especially if I cannot say for how long exactly. Did I miss any more tangible timeline anywhere?


r/MicrosoftFabric • • 1d ago

App Development Cloning an existing fabric app

7 Upvotes

With git support this changes, but without git support, is there a way to download a fabric app if the original creator has lost their local version or has quit?


r/MicrosoftFabric • • 1d ago

App Development App Permissions

3 Upvotes

Does anyone have experience or knowledge of how permissions work with Fabric apps? My basic understanding is that an Entra group needs added to an audience in the app, and no permissions are needed to the workspace containing the reports.

We have an app with paginated reports and what I've observed recently is that users were unable to run the reports in the app until permissions were granted on the semantic model that the paginated reports use. What's odd is I don't think regular (non-paginated) pbi reports work the same way--adding the group to the app audience alone is sufficient, no need to grant to the semantic model as well.

Any thoughts from you fine people? Thanks!


r/MicrosoftFabric • • 1d ago

Certification Hey Anyone give guideline and preparation strategy for DP 700?

2 Upvotes

I have only 10 days to prepare.