Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |