Forum Discussion
import files based on file name in a folder
I have a large data set of various files all being placed in the same folder for example: Bounces_20220703.csv Bounces_20220704.csv Bounces_20220705.csv Clicks_20220703.csv Clicks_20220704.csv ...
In Advanced Editor for Main Query, replace "C:\Test" with your path. Use the below pbix file to test.
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalIn Advanced Editor for Main Query, replace "C:\Test" with your path. Use the below pbix file to test.
Hi,
Apologies are you able to send the code - as i am on my work laptop i still have an older version of Power Bi (cannot upgrade currently) so it wont let me open the file.
- Vijay_A_Verma
Since you are importing files from a folder, it is not a single code. Here is Excel file (you should have Excel, I presume) and you can change the C:\Test in Main Query.
Perfect thank you,
I will mark the original PowerBi one as the solution for people