Get Excel Data from another Excel workbook using Power Query, a better method compared to using Filter formula.

Getting data from another Excel workbook using Excel formula requires the source data workbook to be open in order to perform a data refresh, but using Power Query, this is not required, which makes Power Query a better method to link to another Excel workbook.

The below video demonstrate the 2 methods.