cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Incremental Refresh Data from FILES

Hi All,

I have data in excel files back to 2016. Every week I got reports from different sites. So far I have 284 files in my folder. I am loading data into PBI using Query and Get Data -> Folder. In PBI I've been created one big data table from all files. At this moment 'Refresh' take 20-30 minutes.

 

Is any way to refresh data only from new/replaced FILES? By eg. check date of file. I cant use name of files as they are useless and tell nothing (generated by system) 🙂 like 1525759202512_622296147.xls 

 

All Incremental Refresh Data solution I found referee to SINGLE data table from ONE file. Scenario is same and not suit to me:

- open file,

- open table,

- check date,

- load data from only last 7 days.

 

 

I am working on Premium PBI Desktop ver.2.56.5023 64-bit with some limited functionality set by IT departament.  Please do not advise to update to newest version as I can't - I don't have admin rights and update is set by IT Departament 2-3 times per year.

 

Thx in Advance.

Adam

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Incremental Refresh Data from FILES

Hi @AdamBoltryk

Currently there is no incremental refresh option for folder as you have indicated.

I recommend you to vote for the idea to improve power bi.

Refresh only New Data or Modified File in Folder

Anyway, to solve taking too long time to refresh, 

How about the result if you disable the "Enable parallel loading of tables" option and click specific table in Power BI Desktop to refresh?

1.png

 

Best Regards

Maggie

Highlighted
Helper I
Helper I

Re: Incremental Refresh Data from FILES

Morning Maggie,

Thank you for reply.

I am not sure will it help because all DIM tables are small and IMVHO they are not a problem. I will turn it on and we'll see. My report is feeded by data taken from excel reports automatically generated by main system (KRONOS) and sended on email . I heard we have some project to live connect to data source, but it will not happen in close future. Maybe in a year. Or two. 🙂

Highlighted
Frequent Visitor

Re: Incremental Refresh Data from FILES

thanks, any news considering power BI data flows?

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors