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 know this is an old thread. I have the error "Unable to refresh data type" and was unable to find a solution from the internet.
Thus, I went through all my data and made sure the data types were consistent for each field of all data connections and queries. For example, I used data "type text" and used "type number" instead of "type any" or other number formats, respectively. Then, after saving, closing and then opening the file, the error no longer appears when clicking Refresh All.
In summary, I think the error in my workbook was due to concatenated data with similar but not identical data types. For example, and integer field with a number field.