datasource is hsarepoint. A power BI was already connected to to sharepoint. I have downloaded it and made required changes to it. But, I have not changed any datatype.
When i got to apply the changes ive made in the EDIT QUERIES, the message: "OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))" comes up.
Failed trails:- 1. from many suggestions in online, I have changed datatype. It didnot work.
2. checked if there is any dataa type change happened. But no data type is changed.