Refresh error: OLE DB or ODBC error:Exception from HRESULT: 0x80040E4E ,The command has been cancel

Hi, I haven't seen this solution mentioned so I thought I'd share. I made some changes to column types in Power Query, but since they didn't match what was assigned in Desktop, I kept getting this error message. After changing the column types to match what was in Desktop, the issue was resolved!

For example, I had a column DimAccountID set as whole number in Power Query (transferred over from a SQL database), but it was actually saved as a text column in Desktop. After changing the format from whole number to text, I didn't receive the error message anymore.