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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DavePerks
New Member

Load to dynamic Sheet / Table name when importing from files using Power Query

I have a reporting need each month to import data from a few csv files and store the data in a workbook with each new month of data on a new sheet and table within the current workbook, is this possible with Power Query? I have no issues importing and transforming the data using Power Query, but I need a new table/sheet each month rather than updating or overwriting the current table/sheet.

 

For example I need the import to create this

DavePerks_0-1693835966400.png

 

I need a dynamic version of load table new worksheet adding the name of the current month

 

DavePerks_1-1693836192302.png

 

 

3 REPLIES 3
mussaenda
Super User
Super User

Hi @DavePerks ,

 

You can always import the first sheet of the excel regardless of its name.

Check this: Import first sheet of an Excel workbook into Power Query, regardless of its name – SQL Ryan

 

 

Thanks for taking the time to respond, but this is not the issue/goal I'm trying to resolve. I have no issues importing and manipulating my external sheets and CSV files in PQ, but rather the final sheet/table name that is output to Excel at the very end. I was looking for a way to dynamically create a new sheet/table (the PQ Name) but I'm yet to find a way. I also need to stay away from Macro/VBA due to company limitations/policy. I'm starting to think it's not possible using PQ.

BA_Pete
Super User
Super User

Hi @DavePerks ,

 

No, this isn't a Power Query thing

You can certainly use PQ to import, combine, and transform your CSV files into a normalised table, but it can't dictate the spawning or naming of new tabs. This is probably something that would need to be done via VBA.

 

My recommendation would be to combine your data in PQ, send the whole table to a 'Data' tab or similar, then create a single 'Report' tab that uses that data as a source but contains a single-select month slicer that the end user can use to choose the month they want to view (assuming that each month tab is expected to show the same visuals/metrics per month).

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors
Top Kudoed Authors