Forum Discussion
Excel 2016 - Power Query Error: "Cannot Refresh Data Type" but data refreshes
Suddenly one day last week when I refresh my Excel 2016 Power Query file I receive the error "Cannot refresh data type." However, I click OK and data still refreshes but I do not understand how to f...
I got the same error message and behavior.
Any solution for that?
It is causing issues, when running update with scheduler.
thx a lot.
robertoz I replied earlier, but for me it was as simple as being sure I was online. No idea why as my excel sheet is not online and local, but as soon as I connected to the internet the message went away. The only other thing I did when the message came up this morning was add filter to my master table in excel so thought that the filter did something, but again as soon as I was connected to internet like magic it went away.