Reply
kdas
Regular Visitor
Partially syndicated - Outbound

File Path

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Syndicated - Outbound

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

View solution in original post

5 REPLIES 5
Kedar_Pande
Super User
Super User

Syndicated - Outbound

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
Community Support
Community Support

Syndicated - Outbound

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
Super User
Super User

Syndicated - Outbound

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

Syndicated - Outbound

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?

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)