Forum Discussion
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 possi...
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