Extracting Multiple Tables From A Power Query Combine Folder Source

One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

[oddman]

i have been struggling with this for the past two days... i kept making new queries, and it was cluttering up the project with all these "Parameters" i didnt want... i am so glad i found your video! i was pulling my hair out in frustration.

[nhattruong]

Thank you so much, Reid! This is exactly what I am looking for. Always be a fan of your channel.

[mdhidayat]

Thank you Reid for the video! 👍
Had the opportunity to use this recently because dataflows was not an option.
It immediately eliminate this error - Query references other queries or steps, so it may not directly access a data source.

[TT]

Thank you. This is exactly what I needed.

[heikowingels]

Reid, thanx, perfect! Could copy that one for my current project

[illmtoloko]

5:03 is there a way to Expand all of columns at once? (in case we have multiple columns with tables on it, like importing xml files)

[maxdreamer]

thanks for this video! this was exactly what i was looking for!

[sanjeevsoni]

Brilliant Trick!! Reid thanks very much!!

[tomasdolejsi]

Hello, thanks for a very helpful video. Well done! I would like to ask - would you know why this approach does not work when loading data in a dataflow? I get to "Combine Files" window (2:38) but I am not able to select the folder itself. It can not be selected, therefore I can not process further. Strange thing is that this approach works when normally loading data (not in dataflow). Could you please help? Thanks a lot!

[coleflohr]

Thanks, was missing the trick of selecting the folder instead of a table!

[alfredlear]

😅🤣😅😅🤣😂😅🤣😂
I feel like an idiot for not trying this!
Many thanks, much appreciated 🙏

[girishkumarkp]

How would you convert the created Power BI query to an excel. As explained in video. Once you finish creating the Power BI in case if i want to view it in a single excel how do it Thanks!

[mesneda]

can I do this for a folder in onedrive for business?

[mjboos]

Great video! Follow-up question however. I have a very similar situation however, my two sets of data I want to capture are actually in the same .csv file / same worksheet instead of two separate tables (within the same worksheet file). In other words I have FileA and I want the first 5 columns to go to USER table, and the next 10 columns to go to PAGE_VIEWS. For FileB, first 5 columns to go to the same USER table, and the next 10 columns to go CLICK_VALUES. For FileC, first 5 columns to go to USER table, and the next 10 columns to go to ASSESSMENT_RESULTS. And so on. Hopefully that makes since. Only difference I see is in your example the data is in two different tables where as mine in in the same. Can the combine feature be used in this scenario? Thanks!