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...
The solution of this is simple go to Excel options, Data, Enable data analysis add ins: power pivot.
Now refresh problem solved.