Forum Discussion
Incremental Refresh of a text file
Hello .
I would like to create a historical visualization with text file data.
The same file gets updated daily with new data and I need to apply long script for data modelling.
Is it possible to create a daily power query task to load the data and apply the transformation without losing the data from the previous days?
Details: We don't want to keep several files as data source.
Thanks in advance
Hi, atair ;
Incremental Refresh must:Date column - The table must contain a date column of date/time or integer data type.
For a text file if you don't have date column, it will not work.Refresh is the latest data source can be refreshed, if you start the data source is A, B two rows, the latest is C, D, E; Then c, d, and e will overwrite the original data, which is by design, because PowerBI links to, say, an excel, that changes according to that excel.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-yalanwu-msftCommunity Support
Hi, atair ;
Incremental Refresh must:Date column - The table must contain a date column of date/time or integer data type.
For a text file if you don't have date column, it will not work.Refresh is the latest data source can be refreshed, if you start the data source is A, B two rows, the latest is C, D, E; Then c, d, and e will overwrite the original data, which is by design, because PowerBI links to, say, an excel, that changes according to that excel.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.