Need guidance on the error

[jajatidev]

Hi,
I pull Excel reports with multiple sheets from SharePoint and then manipulate the data in power query. However, I'm getting the following error message while trying to refresh the link with this week's data which keeps failing.

The query is responding to the previous week's report and I don't see any changes or issues with the Excel report.
I also tested the file by initiating to get data from Excel which is responding as expected. I get the error only while trying to refresh the working file with the SharePoint link. Any thoughts on how to overcome the issue?

Regards,
JKD

 

[Matt Allington]

All I can suggest is to open the file in Excel and save it again. See if that helps.

 

[jajatidev]

All I can suggest is to open the file in Excel and save it again. See if that helps.

Thanks for the suggestion. The issue was fixed.
It was a learning for me.