Excel 2016 - Power Query Error: "Cannot Refresh Data Type" but data refreshes

HiBestiaDemona,

in my case there is no Excel running in the background (Task manager).

And the issue still persists 😞

Woopakay72: did you solved this already?

I do believe (at least in my case), the issue is not in the XLSx-file itself, as I am able to refresh the same file in its location from another computer without any issue. I do have all the files stored either on Sharepoint online and few on network drive.

Theoretically it might be the issue with internet connection as Johnmarnell reported - already several months I do have an "pseudo-issue" when the system tray icon from network is constantly tellig me "No Internet access", even though I am connected to computer via RDP 🙂 I was not able to get rid of it, so I gave up, as the PC was connected...

...And now I run Troubleshooter for this issue and this is the fist time ever since Win95, the Troubleshooter identified the issue and was able to solve the issue - the tray icon with "No Internet access" disapeared / changed to standard one. BUT what is better, also the data type issue on refresh DISAPEARED as well. 🙂 I hope it will not come back after refresh. Let me restart ...

Johnnmarnell: many thanks for hint

R.