Can I add 2 data sheets together ( new to existing)

[Jay2077]

Basically I was updating from a spreadsheet which can longer fit any further data on it's going down by dates and I need to add 21st April 2020.  Any help greatly appreciated.

[Anonymous · Accepted solution]

Hi @Jay2077,

You can add a step to get data from other datarouce, then you can write a custom step invoke and combine these tables if they have the same data structure.

let
    Source = Excel.Workbook(File.Contents("E:\xxxxx.xlsx"), null, true),
    Source2 = Excel.Workbook(File.Contents("F:\xxxxx2.xlsx"), null, true),
    Combine = Table.Combine({Source,Source2})
in
    Combine

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi @Jay2077,

You can add a step to get data from other datarouce, then you can write a custom step invoke and combine these tables if they have the same data structure.

let
    Source = Excel.Workbook(File.Contents("E:\xxxxx.xlsx"), null, true),
    Source2 = Excel.Workbook(File.Contents("F:\xxxxx2.xlsx"), null, true),
    Combine = Table.Combine({Source,Source2})
in
    Combine

Regards,

Xiaoxin Sheng

[Jay2077]

 Also am i referring to files on my desk top (not files already within power bi) and if so how do I direct to a certain tab on the excel worksheet?

Thank you for all your help. 

[Anonymous · Accepted solution]

HI @Jay2077,

You can refer to your navigation steps to append them to your source step: (you can modify the item parameter to get data from specific sheet tab that you wanted)

let
    Source = Excel.Workbook(File.Contents("E:\xxxxx.xlsx"), null, true){[Item="Sheet1",Kind="Sheet"]}[Data],
    Source2 = Excel.Workbook(File.Contents("F:\xxxxx2.xlsx"), null, true){[Item="Sheet2",Kind="Sheet"]}[Data],
    Combine = Table.Combine({Source,Source2})
in
    Combine

Regards,

Xiaoxin Sheng

[Jay2077]

Thanks please excuse my ignorance but where do I write the custom step please ?