Main Excel Sheet Not Refreshing

[Anonymous]

Hello All,

Having issues getting one of my Excel sheets to refresh. As you can see in the Model view, the AppendFullProductsShipped has not refreshed in a few months (I've managed to get by with pulling data from our sales tools, but I prefer the PowerBI functionality). The connected files are refreshing daily, so something has broken in the Append Excel sheet. Is there a convenient way to find the defect in the Append sheet without completely starting over? This is a massive Excel sheet with almost a million rows of information. Sorry in advance for not attaching said defective file-it has sensitive sales information that probably shouldn't be shared publicly.

Thanks in advance.

[v-jianboli-msft]

Hi @Anonymous ,

"The connected files are refreshing daily, so something has broken in the Append Excel sheet. Is there a convenient way to find the defect in the Append sheet without completely starting over? "

What is the reason for the data not being refreshed? What happened to the data during the time it wasn't refreshed? Why is it necessary to append new data to the original file instead of creating a new one? Can you please provide more information to help us better understand your problem?

Best Regards,

Jianbo Li

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