Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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.
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 -
Good luck.
If this works for you please mark it as a solution. Thank you.
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.