How to run the same query on multiple tables and append (automatically)

[DatataD]

Hi all,

I've got around 200 csv files which need to be stitched together into the same data table and loaded to Power BI / Power Pivot.

The catch is I can't just load the whole folder in because I need to unpivot each table individually because they have dates running across the top in a row and I need them in the same column (different dates covering around three years) so I can't just filter out all the other date headers.

At the moment I'm faced with duplicating my query 200 times, changing the source to each individual file and then appending them.

Surely there is a better way?

Any help appreciated.

[v-yuezhe-msft · Accepted solution]

@DatataD,

You can define data source parameter in the PBIX file. There is a similar blog for your reference, if you have any questions about the code, please let me know.

https://www.fourmoo.com/2016/11/23/power-bi-using-parameters-for-flat-file-csv-excel-sources/

Regards,
Lydia