Hello,
We initially created a PowerApps application where the source data is being held in the Dataverse as a table. We’ve finalized the application and now we’re needing this data to live on our SQL server. Instead of connecting directly from the Dataverse application to the SQL server, we’ve elected to utilize the Dataverse table due to the formatting and structure of the data. We need the SQL table to mirror what is displayed in the Dataverse table. We’ve gone as far as making a virtual table that mimics the SQL server table but we’re struggling on how to connect the Dataverse table to the Virtual table. Ultimately, we’re wanting the Dataverse table to be mapped to the SQL server table. We’d like to continue to utilize the Dataverse table within our application as the app is completed and we’re just wanting the data stored within our Datawarehouse (SQL Server) and the Dataverse table. Is this possible to do? Any way someone can walk us through how to setup via video conference call. We’ve spent so much time building the application and we feel this is the final step to completing this project. Can someone please help.

Report
All responses (
Answers (