The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 .
Hi, TechR21 if I understand correctly you can duplicate the query for each CSV and change the source in the advanced editor?
@TechR21 , You should use, folder option, and add file to that folder
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
i 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?
User | Count |
---|---|
65 | |
60 | |
60 | |
53 | |
27 |
User | Count |
---|---|
181 | |
88 | |
70 | |
48 | |
46 |