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
Anonymous
Not applicable

Extract data from tab based on similar name

Hello,

 

I am wondering if this is something possible to do.

I receive 30 files per month with two tabs (ie A-aa and B-bb). I need to extract data from tab A-aa. However, some people name it as A-aa, others as A-AA, etc. I am wondering if it is possible to specify the name of the tab so that instead of having Source{[Name="A-aa"]}[Data], I can have Name similar to "aa", for instance.

1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

you can get all column names of a table and filter out only those which are similar to your pattern.

You will need following functions:

And then you'll get a new list of column names which you use for selecting columns of your table.

View solution in original post

2 REPLIES 2
luisrh
Responsive Resident
Responsive Resident

I would instead iterate thru the files in the folder and load them in that way ...   

Here is a blog that helps illustrate the approach -  

 

https://radacad.com/loop-through-on-premises-files-with-power-bi-and-schedule-it-to-refresh-automati...

 

Good luck.

 

If this works for you please mark it as a solution.   Thank you.

 

 

Nolock
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

you can get all column names of a table and filter out only those which are similar to your pattern.

You will need following functions:

And then you'll get a new list of column names which you use for selecting columns of your table.

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.