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.
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!
1. Yes, it happens on all the files with PowerQuery whether it is through Task Scheduler to run the PowerQuery or manually clicking "Refresh All." My back-up has the same issue with his copies of the same files. My reports have been running without incident for nearly four years so something has changed. In my case I don't think it is the computer. I, too, am working remotely but have been since March--this is a new issue.
2. I have not tried refreshing each Query....there are lot of them...interesting test though.We are on Windows 10 with the same issue. I am wondering what Data Type changed that it cannot refresh....or as you said might be an issue with Refresh All. I wish MicroSoft would chime in on this!