Can I merge multiple tables of Azure SQL DB in CDS to create single PowerApp ?

[jayesh040]

I am trying to create single entity in PowerApps by importing Single Azure SQL Database with multiple tables. Few tables have relationship with other tables in that Azure SQL Database which leads to error. To sum-up can I copy my Azure SQL Database to PowerApps as an entity or create create relationship between multiple entity and create single App with multiple datasource(.i.e. Multiple Entities).

[v-monli-msft · Accepted solution]

Hi @jayesh040 ,

You can integrate multiple SQL tables to the same CDS entity using Data Integrator. For more detailed information about this, please refer to:

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator

Regards,

Mona