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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.