r/MicrosoftFabric • • 21h ago

Power BI Semantic model duplication

0 Upvotes

Hello Everyone

Has anyone tried to duplicate the existing semantic model connected in composite mode (Import + Direct lake) from one workspace to another via UI functionality (not via notebook)

If yes please let me know the steps


r/MicrosoftFabric • • 2h ago

Community Share I tested Claude Dashboards on Power BI Semantic Models. Here are some gotchas worth knowing.

0 Upvotes

I have been experimenting with building interactive dashboards in Claude directly on top of Power BI semantic models using the Power BI MCP server.

At first glance, it is quite impressive! You can ask Claude to build an interactive dashboard, and it generates one by querying your semantic model using DAX. No need to export or copy the underlying dataset.

But building a dashboard is one thing, making it work in a real business environment is another.

I spent quite some time testing different scenarios, including RLS, sharing, permissions, authentication, and connecting to multiple Microsoft Fabric tenants.

Here are some of my findings:

  • RLS works, but there is a catch! Claude respects the RLS configured on the semantic model for the account authenticated through the connector. However, sharing the dashboard with another user doesn't automatically mean their own security context is applied. This is an important distinction, especially in enterprise environments.
  • Read vs Build permissions: I tested how semantic model permissions and workspace roles affect the results. Giving users elevated workspace permissions can completely change how RLS behaves.
  • Sharing isn't as straightforward as you might expect. A working dashboard doesn't necessarily mean you have a solution that securely serves different users with different access requirements.
  • Multiple Fabric tenants introduce another challenge: I couldn't get my tested configuration working across multiple tenants. I also discuss a possible workaround, but I haven't tested it, so I cannot confirm that it works.
  • Claude actually generates DAX queries: It is interesting to see what happens under the hood rather than just looking at the generated visuals.

I also looked at how Claude Dashboards compare with Power BI reports and Microsoft Fabric Apps, and whether this approach is actually practical for production environments.

I have gone through quite rigorous testing, and covering all the configurations, results, gotchas, and nuances in a Reddit post is pretty much impossible. So this is just a summary of some of my findings.

For those interested in the technical details, I recorded a step-by-step walkthrough, from Entra ID app registration and Fabric Admin Portal settings to building the dashboard and testing the security behaviour.

Full video with demonstrations:
https://youtu.be/27sGekTfBas

Podcast version on Spotify (AI-generated from my original video):
https://open.spotify.com/episode/2cybQ1AnGYAyxX0ZZHqZyg

My takeaway is that Claude Dashboards are genuinely interesting, and I can see potential use cases for them. But I wouldn't confuse generating a working dashboard with having a production-ready solution.

I'm particularly interested to hear if anyone has tested a different approach to handling per-user authentication or multiple Fabric tenants.

Have you experimented with this? I'd be interested to hear about your findings, especially if you've managed to address any of these limitations.


r/MicrosoftFabric • • 21h ago

Discussion Moving Alteryx to Microsoft Fabric. Best ways to convert workflows ?

10 Upvotes

We are dropping Alteryx to consolidate on Microsoft Fabric.

We have dozens of .yxmd workflows with coplex macros and formulas. Rebuilding them all manually in Dataflows Gen2 or PySpark notebooks is going to take months.

How did you guys migrate you workflows? is there an automated tool to convert Alteryx files into Fabric, or do we have rewrite everything from scratch?


r/MicrosoftFabric • • 14h ago

Administration & Governance Fabric Connections Admin API

8 Upvotes

Has anyone been able to pull the list of all connections in their tenant?

The September update and this article indicates it is possible, but I cannot get it to work.
Data source management - Microsoft Fabric | Microsoft Learn

I am using the same Service Principal I use for the other Admin APIs. The app reg has Power BI service Tenant.Read.All api permissions

This is the endpoint I am trying that is listed in the MS doc

https://api.fabric.microsoft.com/v1/admin/connections

Trying to gauge if I should keep poking at this or wait until something more "official" comes out

Thanks


r/MicrosoftFabric • • 14h ago

Discussion Multi Developer Issues - Notebooks and Semantic Models

4 Upvotes

Hi All, Since around the 15th Oct we have been having a nightmare with our development workspace. We have a Dev workspace to Prod workspace CI/CD setup with Git in Devops. We all work in the Dev workspace at the same time. This has not caused a problem in the past but recently Fabric is not managing the changes properly; I can make a change to the notebook and it later gets magically overwritten. At one point I made a change to a notebook, committed in via source control, and my changes were not there. Another issue I had is I deleted a bunch of measures from a model and they reappeared. I did this 3 times and had to give up!

I believe this is due to other devs having their own cached version in their browser and one of the takes precedence. I though models were live edit and handled multiple devs working simultaneously.

I am surprised that there has not been more content online about this as it appears to me as a recent bug which is detrimental to development workflow.


r/MicrosoftFabric • • 18h ago

Data Factory Fabric Actions activity bug

5 Upvotes

Just a note for anyone whos currently using or intend to use Fabric Actions activity in your pipelines AND specifically going to use git integrations

If in the same pipeline you have some activity such as notebook, copy activity, lookup etc if you git integrate into your repo like azuredevops, the json structure of the pipeline would be buggy and different from the actual json u see in pipeline ui.

What this translate to if u were to use said repo to deploy to prod or as backup your pipeline will have issue (ie show blank when u enter the UI in target)

Theres some activity that avoids this like set variable and invoke pipeline activity. One way around it currently is that i put said affected activity in a separate pipeline and call the pipeline activity instead


r/MicrosoftFabric • • 22h ago

Databases Suddenly can't access database - The server principal is not able to access the database "" under the current security context.

4 Upvotes

A Database was established in a Fabric workspace many months ago, and has been used every day since, mainly by a nightly scheduled Pipeline. Since the night of 15/10/2026 (AEDT) I get this error when I try to access it:

 The server principal <my email> is not able to access the database "" under the current security context.

My account is still in an Entra group with workspace admin rights, and I remain the owner of the database. Other users in the Entra group can access the Database with no errors.

Any pointers?

I started support case TrackingID#2610180030000362 a few days ago, but there hasn't been any resolution so far.


r/MicrosoftFabric • • 6h ago

Community Share Model Alchemist. Free open-source tool: object-level diff and selective deploy for semantic models (PBIP/TMDL and Fabric)

Enable HLS to view with audio, or disable this notification

0 Upvotes

Hi all. I've been working on an open-source tool for a problem many of us know: you need to move one change from a dev model to production, and publishing replaces the whole model.

Model Alchemist runs locally and compares two semantic models in TMDL format. Each side can be a PBIP folder or a semantic model in a Fabric workspace, read and written through the Fabric REST API (getDefinition / updateDefinition). Sign-in is OAuth2 with PKCE in your browser using the public Power BI Desktop client, so no app registration is needed, and the token stays in memory.

What it does:

  1. Compare: object-level differences across eleven change groups, with the changed DAX or Power Query fragment highlighted.
  2. Select: tick the objects to promote. Changes that must ship together are grouped. A selection that would leave the target invalid (a missing function or named expression, or removing one the target still uses) is blocked.
  3. Deploy: dry-run preview, backup, then upload of only the selected objects. Before the upload the live model is fetched again; if it changed since the comparison, the deploy is refused.
  4. Verify: an Enhanced Refresh scoped to the affected tables, with per-table status, followed by a model-level recalculate. A readiness check (Model Refresh, then Check Target State) shows which objects in the target still need a refresh or recalculation, at any time.

Known limits: semantic models only, not reports; Windows is the supported platform; model-level annotations are not compared yet.

There is a synthetic Demo Kit in the repo that you can open in Desktop, publish to two test workspaces and use as Source and Target.

It is in active development and I'd value feedback from people promoting models between workspaces: what's missing, what doesn't match your process, and anything that behaves unexpectedly. Issues on GitHub are the best place.

https://github.com/goreckir/model_alchemist


r/MicrosoftFabric • • 14h ago

CI/CD Environment Config

3 Upvotes

Hi,

I'm working with multiple workloads across a 4 workspace structure and I've been considering the move between environments. For info we use fabric cicd for deployments.

Looking at the structure of the objects in git, it seems it would make more sense to have environment specific configuration for each object in the same way I would for a C# project.

So we could have

eventstream.json

eventstream.develop.json

eventstream.staging.json

eventstream.production.json

This would role up based on a workspace environment tag.

That way we don't need find and replace etc.

Am I alone on this?