Error with refresh

[Anonymous]

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's data. 

As a result i get the message below:

So in my visualisation i have a historical view of sales, orders and so on (sometimes previously 3 months back) and every new month i need it to replace it with the column that has replaced the old column. 

How do i get my visualisation to display what the new raw file displays everytime i refresh. For example using the screenshot above 'forecast history_Jun 21' does not exist in the new file and it will show 'forecast history_Jul 21' instead as the new raw file will only display the forecast history 3 months back

Thank you !

[Anonymous · Accepted solution]

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

Chris Webb's BI Blog: Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh Chris Webb's BI Blog

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.

[edhans]

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.