Forum Discussion

Mattw112's avatar
Mattw112
Helper I
5 years ago

Question on Power Query and Multiple Schemas

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 int...
Need Help
edhans's avatar
edhans
Community Champion
5 years ago

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's avatar
Mattw112
Helper I
5 years ago

Create the table in CDS.

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    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.