Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
@Greg_Decklerthanks it worked.
Cool, I really didn't give that much of a chance of working!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |