Forum Discussion
Create Multiple queries from a single table
Provided that the column names of those tables are all the same, I'd suggest you add a custom column to your existing table with this formula in it:
Table.PromoteHeaders(Csv.Document(Web.Contents([QuerySource]),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]))
This will return the files' contents into your existing table, having all in one place then but filterable (by column "Query/Table Titel") to your hearts contempt. So if you want to produce one report each source/file, you just select a filter criteria on this column when you prepare your reports.
!! You might need to adjust the Delemiter from "," to ";" and the Encoding (1252) to your local settings. You can find them by expanding one single csv file and analysing the automatically created code.
Hi ImkeF,
Thank you for your response. I am actually looking for a solution where the tables are actually not the same, the data I was showing might have the same data columns, but that is not the solution I am looking for. Also, with the data brought together, it actually loses the meaning as each table the table title is the data series label...
Another similar example is I would download a zip file containing 30 or 40 files that have a common column in each and I am hoping to pull in all of these into Power BI, but would rather not have to "get data" 30 or 40 times manually.