You’re offline. This is a read only version of the page.
1,082
We have a single SQL Server that has two databases on it. Two schemas dbo. bi.
In a power apps dataflow power query I am wanting to merge two tables, one from each database together and then load into cds.
I can load them, I can merge them, etc. but when I go to try to create it in CDS it is saying there is an error with schemas. I'm assuming that is because the tables are from two databases? Is there a command or something to merge these or convert the schemas.
Thanks, Terry
Cheers for the update. Keep us posted!
BTW even if it's 200 fields, I prefer to pre-create them in make.powerapps.com which is faster than classic solution explorer. I prefer the flexibility to define the data type and properties for future proofing...
Did you try by creating your tables first? It's worth a try 🙂
Hi @Mattw112IG,
It's probably not because it's a merge from two DBs. Are you system admin in the CDS/Dataverse env, might be a role issue? I would recommend anyways to always pre-create your table in Dataverse before as you will have better control on the table and column settings. Once the table is created, try to map to that existing table instead of creating a new one from a Dataflow.
Hope this helps!
Hi @Mattw112IG,
If you could provide some more detail/screenshots of the issue it would help with assisting. That said, merging and combing queries is a key capability of Power Query and Dataflows so that should not be an issue. The article below provides some good steps on how to bring combined and merged queries from SQL tables into Dataverse.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
