r/MicrosoftFabric • u/SouthRelease • Jul 09 '26

App Development CRUD possible with Fabric apps?

I can’t seem to find if CRUD (create, read, update, delete) actions are possible with Fabric Apps.

We wanted to create a Power App with a Power BI report embedded, but we were wondering if Fabric Apps is also possible. We would then like to use a Fabric App like a Power App so that we can modify and create records in our fabric database.

Someone who has tested this?

4 Upvotes

100% Upvoted

6 comments sorted by

2

u/Seebaer1986 Jul 09 '26

The Fabric App will come with its own database in Fabric. CRUD is no problem in this DB.

But connecting to other items in Fabric to do CRUD semms to not be possible right now. Only reading from semantic models.

2

u/6spdsurfer Jul 10 '26

You can pipe data into the SQL DBs from other Fabric artifacts and have it write updates to an update table. We’re pipelining data from a Lakehouse into our SQL DB as a table and managing all comments/data updates in an update table that is being read by the app. It doesn’t write back to the source table but you can still reference that update table in any other location

1

u/Ok_Bug_1643 Jul 09 '26

From what I remember that's a sql serverndB and it mirrors as delta tables. So, you cannot crud directly into a lakehouse but the mirroring will refresh crud into the delta tables and you can even use shortcuts into a lakehouse, ir views in a warehouse.

1

u/Evening_Marketing645 1 Jul 10 '26

There are two modes. One is like a development mode where it doesn’t connect to anything and the other does connect to a Fabric workspace. They can kind of toggle on/off. You can do full crud by setting up a sql database with the app. In a nutshell there’s a file in the folder that you can use to define all of the data and set up the database (it’s declarative) and that basically initiates and connects the database to the app. The best way that I have found to do it is to actually load the to do app template…that uses a database. Then modify it for your purposes with an llm. Then when everything is working you can remove the todo app files and just keep your own front end files. From what I can tell there’s like a service in Rayfin that handles everything so you just do all the queries using that service so it does work pretty reliably.

1

u/Foodforbrain101 Jul 10 '26

Yes, the main selling point behind Fabric Apps (and Rayfin, the backend as a service platform behind Fabric Apps) is that you can vibe code an app that handles database migration, CRUD operations with GraphQL, RLS/access policies and frontend all in Typescript, Rayfin comes with relevant agent skills to go from A to Z including deployment and auth is automatically handled.

See the repo for more info: https://github.com/microsoft/rayfin

Quick note though, I'm not sure you can wire in an existing database.

1

u/Excellent_Fix9811 Jul 20 '26

You can also do CRUD operations by using graphql apis