Power Apps integration with Fabric

[BharathKumarS]

Hi All,

Should one map the backend of Power Apps to a Fabric SQL database? 

The Power apps is heavily used by more than 50 users with ~100-150 data entries per hour.

And the fabric capacity is a shared one meaning there are other data ingestions job and power bi reports being utilized via the same capacity.

So is it ideal to have a heavy transactional system relying on a shared Fabric capacity?

Also based on the MSFT doc as well, it is not recommened.

What is Fabric Apps (Preview)? - Microsoft Fabric | Microsoft Learn

[v-echaithra]

Hi @BharathKumarS ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @BharathKumarS ,

Thank you @mk_sunitha  for your inputs.

If you get a chance, please review the response shared abiiove and let us know if it aligns with your expectations. Should you need any additional details or clarification, feel free to let us know.

Regards,
Chaithra E.

[mk_sunitha · Accepted solution]

If the question is sharing the capacity across items, this depends on the usage of the application and its child resources [ Fabric SQL DB] based on how chatty your app is with the database. CU consumption depends on the rate of transaction on one or more items. For a scenario with  50 users with ~100-150 data entries per hour, I dont think this would be an issue with Rayfin.  Heavy transactions in the doc is refelecting on thousands of users per second.