Cross-tenant Communication
Pretty new to fabric and cloud infras in general, and wanted to ask whether Fabric provides the functionality to write to another tenant? What I wanted to try is use a tenant to run a script and ET, then Load that data onto another Fabric tenant. There that data will be consumed by Power BI for reporting. And then do that for multiple client (each client will have their own fabric tenant managed by them. Same schema but very small tweaks, if any). Why multiple tenant? Because we cannot have the script on the client's tenant as it contains the credentials for the db. And since we don't have ownership of the tenant, the credentials are never secure (from our pov). Ideally we would want the script and data all on the client's tenant so that the client manage their capacities as they want, but that's future work where we have data available in such a manner that credentials are client-specific. Currently, we connect with the db, fetch all the data and filter for a specific client and give them the report, all within Power BI. Not an efficient or even good way, yes, but we are in the initial stages of product, so can have some leeway. As per my understanding, we have two options for now. First: Create two workspaces, have script in one, and lakehouse in other. Second: Same as above for easier management, but another workspace in client's tenant and allow external data sharing. But whether or not we can write to lakehouse in another tenant from our own, that's what I was looking for. If yes (my initial assessment is no), then how. If no, then why, please also recommend any docs to read as I want to learn how the security is being implemented.