Forum Discussion
Power Query fetching data from file which changes weekly
Hi Kees
I believe you can combine files from sharepoint location as well. Sort by created date and index it and keept the lowest index:
How to combine files from sharepoint:
https://www.youtube.com/watch?v=mYkNDdjbFvo
Another approach we may think of is using a parameter storing file name and using in your query. everytime that parameter is updated, your main query will work dynamically. I can not test your code for this approach, becuase of dummysharepoint address, but I think above shared link might help you.
Hope it helps.
Thanks for your quick response, this solution however is not what 'm looking for for multiple reasons, one of the the file I need is on a sharepoint location, not is a folder used locally.
Trying to find a solution in the direction of addjusting the code in the first message to petch the file...
Again thanks for your suggestion!
Brgds Kees
Hi Kees
I believe you can combine files from sharepoint location as well. Sort by created date and index it and keept the lowest index:
How to combine files from sharepoint:
https://www.youtube.com/watch?v=mYkNDdjbFvo
Another approach we may think of is using a parameter storing file name and using in your query. everytime that parameter is updated, your main query will work dynamically. I can not test your code for this approach, becuase of dummysharepoint address, but I think above shared link might help you.
Hope it helps.