How To Import Latest File From A Folder Using Power Query - Power BI Trick

I hope you enjoy this one!

Have a good one,
Roland

💪 New videos coming every week 🤹‍♂‍
🤘 New short videos coming every week 👨‍🏫

🎬 MORE VIDEOS:
Power BI & Power Automate - How to automate reporting process -

Chapters:
00:00 Topic Of The Day - Import Latest File
00:43 Intro
00:54 BI-Lingual Analytics
01:12 Methods Used Today
01:33 Issue That May Arise
02:50 Solution 1
03:38 Solution 2
04:38 Which Solution Is Better?
05:08 Questions? Comments?
05:21 End

▼▼▼▼▼▼▼▼▼

Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.

▲▲▲▲▲▲▲▲▲

🤝 HOW TO CONNECT 🤝
📍 – Sydney, Australia

📽 GEAR:
📷 – Sony ZV-E10
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light, Elgato Key Light
🎧 – BOSE QC35
🖥 – ASUS VC279H + Xiaomi Mi Curved 34"
💻 – Intel i7-12700K, Gigabyte Aorus Master 3080 12GB, Corsair Vengeance LPX 64GB, Samsung 980Pro 1TB

#PowerBI #PowerQuery #PowerBIPro

[Alan-psul]

Excellent tutorial which has solved the problem I had with multiple files all with same name but different date stamp. Thank you so much

[osPA]

I was having this exact same issue with one of my reports and as soon as I saw that you received the exact same error message I almost jumped out of my chair. Once I found the error of my ways and made the correction...my report was no longer giving me the error. Thank you so much for this video!

[jdsenuk]

Many thanks for showing the 2 methods, definitely solved my problem and I learnt something new.

[samvithb]

You are awesome mate. This is a life saver.❤

[zoltantoth]

Thank you, very interesting! Greetings from Hungary!

[relonicabaldiviano]

Thank you for sharing! This is awesome and somehow similar to what I am looking for. However, my folder path is coming from SharePoint. I applied the same process to option 1 but am having a hard time figuring out how to update the path so it won't cause an error when another file is uploaded in a separate week. Would you please help? Thank you.

[jllxeof]

Roland, first of all, thanks for share these important information. Now, I have a question. I have a power bi file to analyze the revenue of each month of every year of an organization. Each .cvs file have 180mb and every time I want to add the new one, power bi load every file again. It takes a lot of time because I have 15 files now. So I need a way to add the latest without losing the information of the others and keep the way power bi identify each file with a "Source Name" column. Is that possible? Thanks!