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
Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes3 hours agoNew MemberNeed Clarification196Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v3 hours agoCommunity ChampionNeeds Votes36Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_3 hours agoNew MemberAbandoned20Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer5 hours agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos5 hours agoNew MemberNew12Views0likes0Comments