Hi everyone,
My team and I are currently working on a Power Apps integration within Power BI. We have a matrix visual in Power BI, and the requirement is to allow users to add comments for each row directly through a Power Apps visual embedded in the report.
Current Design
New Requirement
The client now wants to use DirectQuery, so the comment data needs to be stored in a database such as Azure SQL Database instead of SharePoint.
However, writing directly from Power Apps to Azure SQL Database requires Premium connectors, which means each user adding comments would require a Premium license. This significantly increases the cost.
Proposed Approach
To reduce licensing costs, I am considering the following architecture:
-
Users add comments through Power Apps.
-
The comments are stored in a SharePoint List.
-
A Power Automate flow triggers whenever a new item is added to the SharePoint list.
-
The flow then writes the data into Azure SQL Database.
This way, SharePoint acts as an intermediary, and the database update is handled through Power Automate instead of directly from Power Apps.
My Questions
I would really appreciate guidance on the following:
-
Licensing Requirements
-
How many licenses would be required for this setup?
-
Would only the developer/owner who creates the Power Automate flow need the Premium license, or would all users who add comments also need it, even though they are only writing to SharePoint?
-
Flow Trigger Limits
-
If, for example, 100 comments are added in a day, will the Power Automate flow run 100 times?
-
Is there any daily limit on how many times a SharePoint-triggered flow can run?
If you need more details, I’ll be happy to provide them. I really appreciate any suggestions or best practices from the community.
For any additional please check below community post:
Advice on Premium Connector
Ashfaque Sayyed
Thank you!
