Forum Discussion
Solved
File Path
Hello! How do I connect PowerBI to the latest file without manually updating the source file path?
Use a folder connector, not a file connector.
Sort the files in the folder by created Date descending (for example)
grab the first item (Row 0 aka {0} )
There are multiple files dropping daily to the same folder path. ie, salesdata_20241001, salesdata_20241002, productdata_20241001, productdata_2024102 so on..
How do I ensuring PowerBi is pulling the latest Product data file from the shared folder?
lbendlin
Super User
Super UserFilter by "starts with product", sort descending, grab row {0}