Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
TechR21
Helper V
Helper V

Automatically 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.

TechR21_0-1690198432916.png

 

Is there a way apply these steps automatically after importing? it cost a lot of time doing it manually .

 

 

 

3 REPLIES 3
JohnShepherdAPD
Helper II
Helper II

Hi, TechR21 if I understand correctly you can duplicate the query for each CSV and change the source in the advanced editor?

amitchandak
Super User
Super User

@TechR21 , You should use, folder option, and add file to that folder

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.