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

Подписаться 7 тыс.

Просмотров 12 тыс.

50% 1

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 -
• Power BI & Power Autom...
Power BI Row-level Security - Complete Guide - • Power BI Row-level Sec...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Secu...
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 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: bilingualanalytics.com.au/abo...
📍 - 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

Наука

Опубликовано:

12 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@Alan-ps2ul 18 дней назад

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

@BILingualAnalytics 17 дней назад

Happy to hear that! :)

@osPA78 Год назад

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!

@BILingualAnalytics Год назад

It is a nasty little thing, right? But it's great that you could solve it!

@jdsenuk 2 месяца назад

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

@BILingualAnalytics 2 месяца назад

Good to hear the video was useful! :)

@samvithb 9 месяцев назад

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

@BILingualAnalytics 9 месяцев назад

I'm glad it helped you! :)

@zoltantoth2267 Год назад

Thank you, very interesting! Greetings from Hungary!

@BILingualAnalytics Год назад

Orulok, hogy tetszett! :)

@unnikrishnansanthosh Год назад

thank you for sharing 👌

@BILingualAnalytics Год назад

Glad you liked it!

@gates1978 11 месяцев назад

Thank you for this video

@BILingualAnalytics 11 месяцев назад

Glad you liked it!

@relonicabaldiviano7163 7 месяцев назад

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.

@BILingualAnalytics 7 месяцев назад

Not sure how it works with Sharepoint, but you can also just load the whole SP folder and in PQ sort by creation date - and then use option 1. Let me know if that helps

@user-jl4lx2eo7f 7 месяцев назад

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!

@BILingualAnalytics 7 месяцев назад

Hey, yes absolutely possible! Try to look at “incremental refresh”. It should solve your problem :) let me know how it goes