Тёмный

Power BI - Connect to Most Recent File in a Folder 

BI Elite
Подписаться 71 тыс.
Просмотров 36 тыс.
50% 1

In this video, you will learn how to connect your Power BI file to the most recently updated file in a folder. This is really handy when you have a folder of files that is constantly updated with new files coming in and you want your Power BI model to pick up on the newest file.
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/

Наука

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

 

13 май 2018

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 43   
@chavelooo33
@chavelooo33 3 года назад
Excellent video, hence you have a new follower and like, I love the simplicity, timing and that you went straight to the point. I love it.
@CS-kw8jl
@CS-kw8jl 4 года назад
Men this is gold! I will check all your videos, great content!
@nurlianaadam
@nurlianaadam Год назад
Thank you thank you thank you thank you for doing a simple yet easy to understand video. You saved me a bunch of time.
@jayduraikkannan
@jayduraikkannan 2 года назад
People usually are asleep at 4.41 AM, boss. Thanks for the tip :)
@Phoenixspin
@Phoenixspin 3 года назад
Dude, you are a lifesaver. Thank you.
@LuanNguyen-pl2wf
@LuanNguyen-pl2wf 2 года назад
nice tutorial, straight to the point
@user-ii7zx5me4o
@user-ii7zx5me4o 4 года назад
thank you ! I've been searching for it.
@BIElite
@BIElite 4 года назад
No problem!
@josericardo3015
@josericardo3015 6 лет назад
Nice Tip Parker! Thanks
@BIElite
@BIElite 6 лет назад
Thanks Jose!
@salosteysv
@salosteysv 6 лет назад
Interesting idea. Thanks!
@BIElite
@BIElite 6 лет назад
Thank you sir!
@dcpowered
@dcpowered 2 года назад
Wow. I didnt know this was possible! Great!
@barttitulaerexcelbart9400
@barttitulaerexcelbart9400 6 лет назад
Thank you. Well explained. No Bullshit. To the point.
@BIElite
@BIElite 6 лет назад
I appreciate the feedback, Bart
@lucaspereira3647
@lucaspereira3647 4 года назад
1 day writing macro in Excel for do this.... But I'm happy with this video. Thank you!
@TheRajinair
@TheRajinair 3 года назад
Thank you!
@OmarAlvarezGarcia
@OmarAlvarezGarcia 4 года назад
Great video! Do you have a solution for only updating the last file on the folder? So we avoid waiting for power query updating the previous months files. Thanks in advance!
@sadyaz64
@sadyaz64 6 лет назад
Thank you
@BIElite
@BIElite 6 лет назад
Thanks for watching!
@juanarmandoarteagasabja6021
@juanarmandoarteagasabja6021 5 месяцев назад
It work !!
@almalleshi16
@almalleshi16 3 года назад
This video is very useful! Thanks much!!! I'm trying to do the same thing for a folder on SharePoint but "date modified" shows "Error" in most of the cases. Do you know how can I use the most recent file from a SharePoint folder? Thanks
@qing856
@qing856 3 года назад
Hello, what if I have 100 files on bi, and now, I want to integrate the101st one? due to the size of the100files, the time of refreshing is too long. is there a way that I can ask bi to integrate only the file101 and dont refresh the previous ones?
@bzflowerbee
@bzflowerbee 5 лет назад
Nice! But, can we use Power Query to perform this? Thanks.
@BIElite
@BIElite 5 лет назад
I think so! I haven't used PQ much in Excel, but this is definitely doable in Power BI
@OmarAlvarezGarcia
@OmarAlvarezGarcia 5 лет назад
What if you have actuals for each month and you only want to refresh the last actuals file for October, is there any way to keep the other data and adding the actuals for October? Since there are a lot of files the appended feature is not an option. Thank you in advance!
@BIElite
@BIElite 5 лет назад
Great question. I'm actually trying to figure out a solution to something similar right now. I hope this post by Matt Allington will point me in the right direction. Hopefully you can get some ideas from it too exceleratorbi.com.au/keeping-track-of-changes-on-a-website-power-bi/
@e4stw1nd
@e4stw1nd 5 лет назад
@@BIElite I was wondering whether you already found a solution for this?
@Mansoorsadat
@Mansoorsadat 3 года назад
I want to keep my previous day's files (information) and only update/refresh for today's file as I am maintaining a YTD trending visual. Any idea how that can be achieved? My folder contains over 500 day's files and refreshing Power Bi desktop everyday means connecting to every single file every day. Ideally I would only want Power Bi to refresh for current day's information. Thank you
@seyedalihosseinighafari7700
@seyedalihosseinighafari7700 3 года назад
Do you know how to do some edit in the file . Thx
@LGS_Inc
@LGS_Inc 4 года назад
So if I have a fold on share point they 4 document per day are dropped into. How can I get power bi to recognize and add those automatic? I have time stamped .csv file that come in from power Automate.
@rajpalpatil274
@rajpalpatil274 4 года назад
I would like to try this ,.. Did it Work on Share point files ?
@aditin7018
@aditin7018 3 года назад
@Michael hello were you able to get it working. Please share the solution if yes. Thanks.
@coolshrawan
@coolshrawan Год назад
Wow...Still Valid. :D
@krushalchaudhary9882
@krushalchaudhary9882 5 лет назад
If I have published this report on POWER BI SERVICES, then if I make changes to the file in the original location on my laptop it does not update the report on POWER BI SERVICES even after a refresh. Unless I manually open the .PBIX file and refresh that in POWER BI DESKTOP. Can you help me with that,? So that I can automate the published reports to be updated without having the need to open a .PBIX and refreshing it everytime?
@rajpalpatil274
@rajpalpatil274 4 года назад
Did you get this sorted @krushal Chaudhary & @BI Elite
@aidohapidoha
@aidohapidoha 2 года назад
hi there! is the process the same for excel files? (u gave an example with txt)
@aidohapidoha
@aidohapidoha 2 года назад
i have a problem. it seems that for excel files it's not the same can anyone guide me with excel files?
@SuhasDevadiga
@SuhasDevadiga 3 года назад
HI team , how to pull files for last 2 quarters from one folder
@seyedalihosseinighafari7700
@seyedalihosseinighafari7700 3 года назад
Super like
@harhour11
@harhour11 2 года назад
I am using the 2022 power bi and the edit button is no longer visible, only combine, load and transform data. What to do?
@JosueLopezXIX
@JosueLopezXIX 5 лет назад
Wow thanks... Watch out Tableau lol
@davida6146
@davida6146 4 года назад
Josue Lopez tableau is already behind....
Далее
Import ONLY The Latest File - Power Query
9:25
Просмотров 19 тыс.
Efficiently extract Data Multiple Folders in Power BI
12:50
Despicable Me Fart Blaster
00:51
Просмотров 9 млн
DEFINITELY NOT HAPPENING ON MY WATCH! 😒
00:12
Просмотров 31 млн
Handling MULTIPLE fact tables in Power BI
9:02
Просмотров 298 тыс.
Power BI - Connecting files in a folder
10:24
Просмотров 49 тыс.