Power BI to look in each Excel files in a folder to see if particular columns exist prior combining

[smpa01]

Hi,

Is it possible for PBI when connected to a Local Drive Folder to look into each of the excel files contained within the folder to see whether each of those excel files contain ceratin columns specified by me.

e.g. I have a folder called "Test" in My Documents and I have been saving some excel files in that folder for example, 1.xlsx; 2.xlsx; 3.xlsx. Is it possible for PBI to see if each of those files has columns called "ID","Name" and "CIty" which may or may not exist within those files. The files which contain all 3 columns , I am only intrested in combing the contenets off those files.

Is there a way to acheive this?

Thank you in advance.

[Greg_Deckler · Accepted solution]

Maybe via a Combine Binaries (Folder) query. If you selected the columns that you want in your sample file as your first step (getting rid of all other columns) then it might work.

[smpa01]

@Greg_Decklerthanks it worked.

[Greg_Deckler]

Cool, I really didn't give that much of a chance of working!