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
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..
Thanks for all the feedback. If there isn't already a request for this on the UserVoice, it would be great to add one.
konstantinos Thank you for the link. It works - I am now able to refresh my folder data! Nevertheless I think it would be good option to be able to refresh data from a function as well!
I totally agree that it has to be solved. Althouth It has working workaround when you use „From Folder“ datasource instead of configuration table with file paths. But when I need to work e.g. with Web.Contents from different web or sharepoint locations then it doesn’t have solution yet. Thanks for solving.
