Forum Discussion
Excel 2016 - Power Query Error: "Cannot Refresh Data Type" but data refreshes
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.
Not that I have found and no one else has replied to this post for a possible solution. My Power Query also runs on Task Scheduler but does not seem to interfere with the data refresh. If/when I hear of or find a resolution, I will post it here.
thx Woopakay72
btw. it is happening on all my excel files when using Refresh All icon.
However I have just realized:
1. when I start Refresh All for the same file, just from another computer, it runs without issues => means the issue seems not to be related to the specific file, rather to the computer or its installation
2. when I start refresh query by right click menu one-by-one query only, it runs without this message => means the issue might be somehow connected to Refresh All functionality...
One note here: computer, where the issue appears, I am accessing via RemoteDesktop. But the other computer I tried and worked well, I am logged in directly/locally. Both computer have exact the same Version of MS Office: Version 2009 (Build 13231.20262)
R.
Well, I have read more about Excel's Data Types and found the following (will see if I can find the site where I read this information and post it.):
- Any columns of data that cannot refresh the data type will be blank. This is only a problem if those happen to be the columns of data you need for your report.
- "Cannot refresh data type" does not keep the file from refreshing.
- I found in one of my sub-queries five columns with a question mark at the top--they had no data type--good news is they don't affect the data I pull into my report. I added a data type but unfortunately did not fix the issue. I must have other columns where there is no data type but haven't checked yet. So is it possible that MicroSoft removed a data type and that's why this error is occuring I wonder. My report is over 4 years old and never touched the data types.
Hope this helps!
