Data Flow doesn't refresh when file is replaced on SharePoint

[_Slowpoke]

Hello everyone,

I have a flow that is connected to some (relatively big) excel files on SharePoint.

But whenever I update the file by deleting and replacing it with a similar that include some more rows, the next auto-refresh doesn't work and it tells me that the File contains corrupted data. But, i just have to open the excel file, and manually refresh the request on online power query to make it work (so but just reloading the data).

Would you have any idea on how to avoid this type of issues?

Thanks by advance.

[ibarrau]

Hi. The data refresh is that. Data refresh. If you modify the structure like columns names it will probably fail because you might have transformations applied to specific columns that later are not there. That's not an issue, that's the way technology works. If you just want to add a column automatically then it depends on the source and your code if that will be applied. For example, when combining files, there are some tricks to help you add a column on a file and let it loaded it on the data when refresh: https://www.youtube.com/watch?v=CkH2Ocrut3s

I hope that helps,

[_Slowpoke]

I do not modify the structure of the file, the column stay the same and the transformations are just: deleting the first 3 rows, updating the columns names and attributing them datatypes.

I do not want to add or remove column, the file stay practically the same, the only change is that some rows that follows the initial structure of the document are added.

That's why, I don't unsterstand why it doesn't work as data refresh is that: when the structure is not modify, it shouldn't fail.