Hi everyone,
Thanks in advance for any suggestions with this.
We've recently created a new Sandbox / dev PowerPlatform environment and have migrated one of our existing Solutions to it to carryout some development work. The production solution involves using a DataFlow via data gateway, to sync from a SQL Server database view to a CDS entity / Dataverse table. I want to use test data in this environment, so I've used a DACPAC to recreate the production database on a test SQL Server instance. I've set up the connection on the gateway and have successfully setup a connection in the sandbox environment with status connected. However, when I attempt to access that database, either via a DataFlow or Flow / Power Automate, I can't see any of the tables or views (see below images). Yet if I attempt to connect to the production SQL server instance, I can successfully see the tables and views. I have double checked the permissions on the test SQL Server db, and the gateway itself. I can't see any issues, and these were included as a part of the DACPAC anyway.
Any suggestions would be greatly appreciated, and please let me know if I've missed any important details.

Report
All responses (
Answers (