Forum Discussion
Error with refresh
Hi All, I have a couple of files imported where everytime a new updated file is generated it replaces the existing one. The new file(s) that replace the old ones always removes the previous month...
Hi Anonymous ,
Power BI will not store data, unless you have a query source that will support incremental refresh.
Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You need to dynamically rename the columns in the file as they come in. This article will walk you through the steps. Renaming A Column In Power Query Based On Position — ehansalytics - just remember that whatever position the column is in, subtract 1 because Power Query starts at 0, not 1.