u/bigjimslade

How are teams managing Fabric branch-out workspaces + Workspace Identity connections?

We’ve built a Microsoft Fabric development process using Deployment Pipelines for shared semantic models and Git branch-out to give each developer their own workspace.

For Dev/Test/Prod, we’d like to use shareable cloud connections authenticated with Workspace Identity. The problem is that when a developer branches out to their own workspace, the Workspace Identity shared cloud connection doesn’t seem to work when editing the model. perhaps I'm missing a configuration or setting?

it seems like the shared cloud connection works fine for refresh, however when you edit the model. I get a warning

To avoid semantic model refresh errors while developing, we end up changing the connection to a per user OAuth/user credentials in the developer workspace.

Our current thinking is:

  • Developer branch-out workspace → OAuth connection
  • Shared Dev → Workspace Identity connection
  • Test/Prod → Workspace Identity connections
  • Rebind the semantic model to the appropriate managed connection during integration/deployment

It works, but having developers switch authentication feels like extra complexity and potentially something we shouldn’t need to manage manually.

For teams using Fabric + Git + branch-out + shared semantic models, how are you handling connections and authentication across developer workspaces?

I'm also curious about what happens or needs to change when development is done outside of the workspace in power bi desktop.

reddit.com
u/bigjimslade — 18 hours ago

Hybrid Approach for git integration and CI|CD

We are in the process of designing our Microsoft Fabric CI/CD process and would like a sanity check from others who have implemented this in production. for now ,the focus is primarily on shared enterprise semantic models.

Microsoft documents several deployment approaches:
https://learn.microsoft.com/en-us/fabric/cicd/manage-deployment

Rather than choosing a single option from the link above, we're considering a hybrid approach (Blending Options 2 and 3 from the link above):

  • Each developer has their own Fabric development workspace.
  • Each developer workspace is connected to an Azure DevOps feature branch.
  • Changes are made in feature branches and merged to main through Pull Requests.
  • Our shared Dev - Models workspace is connected to main and acts as the integration workspace.
  • We use Fabric Deployment Pipelines to promote changes:
    • Dev - Models → Test - Models
    • Test - Models → Models (Production)

The overall flow looks like this:

Developer Workspace
        │
        ▼
Feature Branch
        │
        ▼
Pull Request
        │
        ▼
main
        │
        ▼
Dev - Models
        │
        ▼
Deployment Pipeline
        │
        ▼
Test - Models
        │
        ▼
Deployment Pipeline
        │
        ▼
Models (Production)

To me, this seems like a natural combination of:

  • Option 2 for collaborative development using feature branches and PRs.
  • Option 3 for controlled promotion across environments using Deployment Pipelines.

Has anyone implemented something similar?

I'm particularly interested in:

  • Whether you've run into any issues with this approach.
  • Whether you consider this a recommended pattern or an anti-pattern.
  • Any lessons learned around keeping the Dev - Models integration workspace synchronized with main.

I'd appreciate any feedback from teams running Fabric in production.

u/bigjimslade — 1 month ago

SSMS still prompting for multiple credentials when accessing Fabric endpoints

I'm hoping to get some visibility to this bug that appears to have been open for 7 months with seemingly no traction with the SSMS product team.

when SSMS connects to a Microsoft Fabric SQL Warehouse or SQL analytics endpoint prompts users to authenticate twice with Microsoft Entra ID.

Here is a link to the original thread:

https://www.reddit.com/r/MicrosoftFabric/comments/1p2h98j/ssms_22_connection_to_fabric_sql_endpoint_2_login

and here is the user feedback issue:

https://developercommunity.visualstudio.com/t/Entra-MFA-is-being-requested-twice/11001117

Surprisingly, it has relatively few votes which may explain why it isn't getting any love from the engineering team. Please help raise visibility by upvoting this. It is extremely annoying.

if anyone has any reliable workarounds, I'm all ears.

reddit.com
u/bigjimslade — 2 months ago

Fabric Data Pipelines: Circular Dependency Warning

https://preview.redd.it/sfgyxihs9o9h1.png?width=737&format=png&auto=webp&s=0e2648cc21cb904c65850f268be4d68dad86d475

Two Questions:

  1. I can't quite work out what this error is trying to tell me? I parameterized the workspace, connectionId and the pipeline name. I feel like maybe it is a false positve?

  2. I can't seem to workout how to copy and paste the full or any of the text in these boxes.

I feel like the UI needs a copy button and an expand button. Additionally, the only way to see the whole text is to hover over it. (I'm using the latest version of edge).

This is super frustrating and I don't recall having this problem previously when copying and pasting

the UI in ADF allows you to select the text and copy it.

reddit.com
u/bigjimslade — 2 months ago

Hey folks, I’m trying to understand the difference between these two PowerShell tools for managing Microsoft Fabric:

  • FabricTools (dataplat/FabricTools) — community-driven, open source
  • MicrosoftFabricMgmt (in the microsoft/fabric-toolbox repo)

Other than one being community-run and the other living under Microsoft’s GitHub, I’m a bit unclear on how they really differ.

A few things I’m wondering:

  • Are both still actively developed?
  • Do they mostly do the same things, or target different use cases?
  • Is one more “official” or production-ready than the other?
  • Any real-world pros/cons if you’ve actually used them?

Trying to decide which one to standardize on for Fabric workspace/capacity management. Would love to hear what people are using and why. Thanks!

reddit.com
u/bigjimslade — 4 months ago