Unanswered

How to write directly to Fabric from Power Apps

(1) Share

Report

Posted on by MRBCODC

We are looking to migrate all our data to One Lake/Fabric/Data warehouses as out one stop shop for all data coming in from external sources and power apps

Currently we are using share point for our power apps but we want to use Fabric as our data source as we already have snowflake data there that currently uses flows to import to share point for Master Data which the power apps use.

We have used some data flows to test getting existing data in to fabric which works but when we use the SQL connector to try write to tables in data warehouse we get error that the table is read only or dose not have a primary key.

We have identified that for some reason primary key is not supported in data factory.

Without using Data verse (Which is obscenely expensive from the amount of apps and users we have) how can i write data directly to Fabric and use fabric as my data source for forms and galleries etc.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mikaeldavidsson 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you made any progress on this. I have the exact same problem but we have an on-premise Warehouse that is beeing replaced with fabric + Power Apps for write back. I have not found a solution yet that allows for direct feedback in reports when saving.

//Mikael

Was this reply helpful? Yes No
MRBCODC 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, I have still not came up with a solution to get this working the only option I have right no is to have and Azure SQL as the Database for my apps then have a daily/scheduled dataflow to sync with fabric but I am not keep on this as you will be duplicating tables.

Was this reply helpful? Yes No