View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time or effort. If you’re still learning the basics of Power Query please refer back to an earlier post here.
This demonstration will show you how to use Power Query to scan a file folder to search for a set of files to load. Then load the contents of multiple files all at once and use transformations to format the data appropriately..
Hope this helps!
Other posts by DevinKnight