File Path

[kdas]

Hello! How do I connect PowerBI to the latest file without manually updating the source file path?

[Kedar_Pande]

Take a look at this video: https://youtu.be/pHDRKNjuwmU?si=mCpZO7WrTFhrN1fa

Your Kudos/Likes are much appreciated!

If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.

Regards,

Kedar Pande

www.linkedin.com/in/kedar-pande

[v-denglli-msft]

Hi @kdas ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .

Thank you very much for your kind cooperation!

Best Regards,
Dengliang Li.

[lbendlin · Accepted solution]

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}  )

[kdas]

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]

Filter by "starts with product", sort descending, grab row {0}