Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
huzefa_53
Helper I
Helper I

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

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  

3 REPLIES 3
lbendlin
Super User
Super User

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

Anonymous
Not applicable

@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.

please show a sanitized version of your Power Query code.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.