From the course: Power BI Data Methods (2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Combining binary files with formulas
From the course: Power BI Data Methods (2019)
Combining binary files with formulas
- [Instructor] Remember we defined binary objects as files combined or read using other functions. Excel and PDF files for example typically contain multiple tabs or tables in them or what Power BI knows as table objects. We previously drilled into single binary objects contained in a folder connection to see the table objects in them and combine them. However, if the folders contain many tabs or tables, we first need to read the file using a formula to extract the tables or the tabs from within them. Then we can combine this into a single data set. We previously set up a connection to a folder of NOAA CSV files. And when we combined them, we lost the file and path details. Let's try to combine the CSV files using another methodology, which includes a formula. We first duplicate our NOAA CSV query. I'm going to rename this with formula on the end. We're now going to read the CSV files instead of combining them by creating…
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.