Solved: Join two data bases

buchelir · ‎05-08-2018

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

v-yulgu-msft · ‎05-08-2018

Hi @buchelir,

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

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yulgu-msft · ‎05-08-2018

Hi @buchelir,

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

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

buchelir · ‎05-09-2018

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

MFelix · ‎05-08-2018

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

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português