Incremental Refresh Column wasn't found

[Anonymous]

Hi community, hope you are doing well.

I need help with some issue. I did a solution which get information for a set of Excels uploaded to a Sharepoint folder. I need to do an incremental refresh on this because the data is huge, and it's growing up month by month. I followed the steps, set the parameters Range Start and Range End, and set the filters, but when I published it and tried the refresh, I got this error:

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The column 'File Name' of the table wasn't found."}}],"exceptionCulprit":1}}}

It is weird because if a take off the Incremental Refresh, the scheduled works well. I tried to filter manually the data in the desktop as if the IR would do, and the 'File Name' columns appears ok, so I dont know if I'm messing with something else. Any idea?

Thanks in advance!

[v-lionel-msft]

Hi @Anonymous ,

Try to refer to the links.

Power Query / BI - Data Refresh Error: The column 'Activities' of the table wasn't found 

Expression.Error: The column 'Amount' of the table wasn't found 

Expression.Error:The column "xxxx" of the table wasn't found. 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

Without more details it would appear that you might need to change the way you do your incremental refreshing.

Here is a blog post explaining this: https://www.fourmoo.com/2020/07/01/how-to-configure-incremental-refresh-with-power-query-in-power-bi...