Рет қаралды 70
Monkey Tools contains a collection of Query Monkeys who will inject useful Power Queries into your workbooks on demand.
In this episode of Using Monkey Tools we will explore Monkey Tools SmartFile Monkey which accepts a file path, and returns the file. Why is this so special? Four reasons:
1) Like our free SmartFile function, you don't need to pick the specific data source connector, just pass the function a valid file path.
2) It can deal with a file path that switches between a local hard drive or SharePoint file path
3) Coupled with the free Parameter Table & Function, it allows you to build dynamic file paths that are relative to where your solution is stored.
4) The Monkey hooks all the pieces together for you with a single click, eliminating ALL of the busy-work in setting up this solution!
If you build solutions for others and are tired of walking the user through changing the file paths when they receive their solution, this function is for you. And in this video, we'll show you exactly how to set it up to work.
NOTE: If you are a free license holder, check out the video on the SmartFile function. You'll need to tie the pieces together manually, but it can be done entirely for free!