Question on Power Query and Multiple Schemas

[Mattw112]

We have a single SQL Server that has two databases on it.

Two schemas

dbo.

bi.

In 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 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 soemthing to merge these or convert the schemas.

Thanks,

Terry

[edhans]

When you say you can load and merge, I understand that (though that is extract and merge really), but what do you mean when you say "create?" 

[Mattw112]

Create the table in CDS.

[edhans]

I'm not sure what that has to do with Power BI. You might need to check out a forum on putting SQL data in CDS.