Forum Discussion

buchelir's avatar
buchelir
New Member
8 years ago
Solved

Join two data bases

Hello everyone,

 

It´s possible in Power BI to join two data bases that are in Excel? (I´m new in Power BI). My problem is that in one base I have data from 2017- 2018 and the other one have data from 2015-2016 and I need to be in one file in order to make a report. I can’t join those two data bases in Excel because they are too big to be manage in Excel.

 

Appreciate your help.

 

Thanks,

RB

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi buchelir,

     

    You can use the Files from folder option where the treatment of the files is done the same and the end result is a single database based on several files.

     

    Check this link.

     

    Regards,

    MFelix

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi buchelir,

     

    If you load data file separately into desktop, you can append multiple datasets into a single one.

     

    Best regards,

    Yuliana Gu

    • buchelir's avatar
      buchelir
      New Member
      8 years ago

      Thank you very much Yuliana, you help me a lot.