Fitbit Data Integration with Power Query
This is real use case for Power Query through an example. In this example you will learn how custom functions can be used with parameters to expand a data transformation applied on a CSV file to all files under a folder. The solution implemented with this method can be refreshed and pick the new data set anytime a new file appears in the source folder. You will learn how to apply simple data transformation in Power Query, how to change the whole transformation set to a function utilizing a parameter, and how to search through files in a folder, and apply function on all files and combine the whole result set.