From the course: Power BI for Finance
Join today to access over 24,900 courses taught by industry experts.
Folder - Power BI Tutorial
From the course: Power BI for Finance
Folder
- [Instructor] We can connect to a folder of flat files in Power BI and then combine the tables within them into a single query table within Power Query. It's helpful if the files follow a similar structure and/or file type, with similar column names, order, and data types within each of them. Similar to our CSV and Excel file connections that we already set up, we can utilize the functions CSV.Document and Excel.Workbook to extract the data from a file and the tables within them. In the Data folder of our exercise files, I added two additional folders that contain the same data as the Actuals Excel workbook, but they're split up into separate files as both CSV files and Excel workbooks. From my own personal experience, I've learned that folder connections are very helpful tool for working with data. Often, we'll see data come in every month, and we need a way to combine them together. We can always switch out our connections later too, as we'll see. To get data from a folder, we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.