Forum Discussion
Create Multiple queries from a single table
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.
The only way I'm aware of where multiple queries are created with "one go" are selections from a database. So no further idea here from me.
Also didn't understood the reasons for your refusal (about data loosing their meaning cause title needs to go into data series label). If you drag the title column into "Report label filters" and choose your "tablename" there it will be as if you were acting on that specific (separate) table - no need to show anything from that field in your charts/reports.