Forum Discussion

ingridsantana's avatar
ingridsantana
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Merge different databases

Hi, I have a database that I update monthly from Excel for Power BI. The layout and panels for the year 2017 are all ready. When I want to insert the 2018 information into the base worksheet, from Ex...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ingridsantana,

 

Two ways for your consideration:

 

You can import the Excel for 2017 and 2018 one by one, you will get two separate datasets in Power BI desktop, then you can manually append the 2018 dataset to 2017 dataset in Query Editor mode.

 

Alternatively, you can place the all excel files in a single folder. In desktop, choose "Folder" rather than "Excel" under the data connector list. For details, please see:

Load Multiple Excel (xls or xlsx) Files

Power BI – Importing Multiple Excel Sheets

 

Best regards,

Yuliana Gu