Forum Discussion
Import multiple csv files from folder into separate tables based on date conditions
Hi there, I want to import multiple csv files in a folder. In the below example, I have 3 csv files in the folder. How can I import only 2 of the 3 files based on the date in the f...
Thanks, MaxShema .
Sorry, I am brand new to Power BI, so need a bit hand holding. Appreciate it!
in the step #1 Create a new Query and name it as "data_current"
- this is what i did: righ click in the Queries pane (on the left) -> New Query -> More -> Folder (where csv files stored)
- then, on the right side, I have a new "Source" under the Query settings
step #2 Add as a source for this query your folder with the csv files
- what do I need to do for this step
in step #3 Extract the dates from the names to the separate column
- I don't know how to insert a step and get a fomula bar that is only for the step
- I tried to right click in the Query settings, and "insert Step after", but no independent formula bar to allow me to enter codes.