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 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

Need Help

3 Replies

  • 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?" 

      • 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.