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
37 Comments
- jaing10213New MemberYes, I would love this functionality
- martijn41New MemberMe too!
- nparama1New MemberI really need this function, cause, the old files dont change, i only need to update the last file or the last modified file. Updating the rest of the files, it onbly makes the update more slow.
- bhrdrmsFrequent VisitorYes, Every customer ask this function. it would be excellent.
- adam_boltryk1New MemberInteresting why only 14 votes on this CRUCIAL function. Leaving aside the fact that the designers / programmers / developers from Microsoft have not thought about it from the beginning ... 40 minutes refresh every day is not funny... I need it...
- stephane_onckelNew Member'I agree with Nicolas P and would like a functionality that would enable Power BI to consider new and updated files only, since thew last Refresh. Example (Date Format DD.MM.YYYY): - Power BI: Last Refresh Finish Timestamp: 03.10.2018 @09:00:00 - Excel file1: Last Updated Timestamp: 16.09.2018 @15:30:00 > Do not import file - Excel file2: Last Updated Timestamp: 04.10.2018 @08:15:00 > Import file (and "crush" the corresponding data already imported into Power BI during the last refresh) - Excel file3: New File posted 03.10.2018 @20:30:00 > Import file
- mhaleebRegular VisitorMe too
- paul_schafferNew MemberAs 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!
- alvaro_jose_r_sNew MemberI 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.
- gutlapally_anilNew MemberPlease add this asap. badly need this.
Recent ideas
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels4 hours agoAdvocate IIINew183Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen5 hours agoAdvocate INew293Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi5 hours agoMicrosoft EmployeeNew21Views6likes0Comments