Forum Discussion
Refreshing queries with functions doens't work
Maybe try this approach..and filter the latest file by date created..Needs more code but it worked - refreshed in PowerBI V1 so probably it will work in V2 as it doesn't use parameters..
Like the second one. In one of my reports I have a folder with alot of excel files, which are exported from another software. The structure of the files is always the same. The files are exported every day and in the naming of a file there is the current date - so the naming changes from day to day.
My approach is to query the parent folder, sort the files by date and remove all files except the newest. Then I insert a new column and call a function on the filepath of my filtered excel files. I have to do that, because the excel files have a bad structure so the table in a single file has to be rearanged before I can combine.
The problem is that the amount of files changes from day to day. So for example on monday there are more files to query than on a saturday.
My case is more or less like in this powerQuery tutorial: https://youtu.be/KXxUDWwo0pg?t=2015
I'm using the same approach as bloigge. My client has many excel employee's timesheets with same structure. When will be this functionality supported for schedule refresh?