Pull data from another excel document

Question

I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls.

I want to automatically pull the data from ABC and PQR to XYZ. Is there any way?

All three documents are saved in same share point location in my computer.

Unfortunately, i cannot make it as multiple sheets in same document.

Can it be done by Power BI?

jkpieterse · Answer

If you are pulling similarly shaped data (for instance, a table in both files with the same columns), then you can use Data, Get Data, From File, From Folder to do this. See https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4

Forum Discussion

Pull data from another excel document

1 Reply