Please forgive my over explaining. I am new to Power Automate.
The end goal is to keep our back end calculations hidden within our Power BI, but allow for clients to use PowerApps we customize, or they may customize as well, for them to enter in data on the client side and tie it to their internal data as well. Editing the records, or creating new ones must cause the records data to be sent to us. Once we receive the updated field information or entirely new records, we need it to upload into the appropriate matching records on our side, run the calculations and automatedly send the calculation results within our CDS back to the client's Portal to be displayed. It is fine if there is a delay.
The challenge is that we can't directly connect 2 CDS, in 2 different tenants, so have to use a work around.
I am open to pretty much any way of solving this challenge. Was thinking it may make sense to send entire datasets back and forth some how. Either by automatedly making and sending an exel, or by synchronizing the CDS to a mirroring SQL somehow, and then syncing through SQL?