I have a question about the PowerApps Portal Licensing and related Data transfer rates. I am working on a setup a PowerAPPs Portal with CDS DB backend which does the data collection using few Web forms. The data is thats stored in CDS database of Portal then needs to be brought in the on-prem SQL Database using some mechanisms.
So the questions are:
What the best way to bring the data from SaaS instance of Portal's CDS database to on-prem SQL database.
Do you need to have a DataGatway (on-prem) be setup to meeting the requirements or some sort of data pulling mechanic can be used (e.g. windows service/API) to meeting the data pull requirements.
And finally and the most important question - is there any cost for data transfer (i.e. EGRESS) when taking out the data from CDS (cloud) to store in on-prem SQL DB.
Any help in getting above queries answered will be highly appreciated.