Skip to main content

Power BI

Needs Votes

Refresh only New Data or Modified File in Folder

Vote (225) Share
's profile image

on 26 Jul 2016 13:11:29

My data read from a folder. Everyday I will put in a new file into the folder and when click refresh it will refresh all file in the folder which is time consuming. Can we have an option to "refresh only new file".

The process of "refresh only new data" will be:
1) Any last modified file: based on modified date and changed name (so that it wont confuse as new file)

2) Any newly included file

Comments (36)
's profile image Profile Picture

luojiandan on 16 Aug 2020 04:11:45

RE: Refresh only New Data or Modified File in Folder

最基本的功能,桌面端请加上此功能!

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:11:13

RE: Refresh only New Data or Modified File in Folder

PLEASE MICROSOFT PUT THIS BASIC FUNCTIONALITY IN PBI DESKTOP. THIS SHOULD BE A BASIC FUNCTION AS MOST PEOPLE WHO USE THIS HAVE NEW UPDATED FILE EVERYDAY (OR WORST EVERY MINUTE) AND THE ACCUMULATION OFTHOSE FILE MAKE IT HARD AND SLOW FOR PBI DESKTOP TO LOAD AS IT REFRESHES ALL DATA INSIDE THE SOURCE FOLDERR!!!!!!!!!!!!!!!!!!!!!!!

MY NEWLY ESTABLISHED COMPANY WHO HAVE GONE DOING LAST ROUND OF INVESTMENTS IS KEEN ON POWERBI TO BE INTRODUCED ON THEIR OTHER COMPANIES (CANNOT DIVULGE HERE THE INFORMATION) BUT WHEN THEY SAW THIS DURING MY PRESENTATION THEY KNEW THAT IN THE LONG RUN IT WILL BE A PROBLEM ESPECIALLY FOR MANY AND HUGE DATA SETS

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:11:13

RE: Refresh only New Data or Modified File in Folder

Please add this one. This should be one of the most basic you should have in power bi desktop

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:11:13

RE: Refresh only New Data or Modified File in Folder

Please add this one. This should be one of the most basic you should have in power bi desktop

's profile image Profile Picture

Martin Spalding on 16 Aug 2020 04:11:10

RE: Refresh only New Data or Modified File in Folder

MUCH REQUIRED!!

's profile image Profile Picture

Martin Larsson on 16 Aug 2020 04:10:01

RE: Refresh only New Data or Modified File in Folder

Please add this function

's profile image Profile Picture

Anil kumar G on 16 Aug 2020 04:09:33

RE: Refresh only New Data or Modified File in Folder

Please add this asap. badly need this.

's profile image Profile Picture

Álvaro Santos on 16 Aug 2020 04:08:51

RE: Refresh only New Data or Modified File in Folder

I have 25 Gigs in Data Lake Store and powerbi consuming the files, everytime that i make a refresh takes 40 minutes, i think this is a must.

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:48

RE: Refresh only New Data or Modified File in Folder

Me too

's profile image Profile Picture

Paul Schaffer on 16 Aug 2020 04:08:28

RE: Refresh only New Data or Modified File in Folder

As much as I would like to link my PowerBi to an online or SQL data source, I can't. So I have to rely on downloading the data to Excel Files first. With every additional week the refresh takes longer and longer. Please, Microsoft, include this in the features!