I want to get all tables with prefix name in query editor

[huzefa_53]

Hi, i am looking for a way in order to pick all tables with prefix name lets assume (huzefa) and append all tables together dynamically  on runtime i don't know how many tables with prefix huzefa exist and in future if another table comes so it could be handle through this query  

[lbendlin]

Needs more details. Is that a SQL source, Excel source, or folder source?

[AaronApexPeak]

@lbendlin I have the same question and I am using Postgres.  All of my prefixed tables have the same columns so there will be no issues aligning data.

[lbendlin]

please show a sanitized version of your Power Query code.