Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello! How do I connect PowerBI to the latest file without manually updating the source file path?
Solved! Go to 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} )
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
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.
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?
Filter by "starts with product", sort descending, grab row {0}
User | Count |
---|---|
115 | |
106 | |
102 | |
78 | |
44 |
User | Count |
---|---|
143 | |
142 | |
122 | |
100 | |
57 |