Forum Discussion
Helper VAutomatically duplicating steps in power bi query editor
Hi,
Each month I want to import a set of csv files. These files always have the same structure and columns etc each month. I apply a number of steps to these files and after I make a few reports.
Is there a way apply these steps automatically after importing? it cost a lot of time doing it manually .
3 Replies
- amitchandak
Super User
TechR21 , You should use, folder option, and add file to that folder
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
TechR21i know this option but its not what i meant. Maybe i wasnt clear enough. The importing is no problem. But after the importing there has to be a number of steps applied to the file. And my question was, if there is a way to have this automated, so that these steps are applied after importing?
JohnShepherdAPDHelper II
Hi, TechR21 if I understand correctly you can duplicate the query for each CSV and change the source in the advanced editor?
