Forum Discussion

asingh's avatar
asingh
Regular Visitor
8 years ago
Solved

Created survey in MS Forms and get error message

I created a survey for work in MS Forms and I pulled the data into Power BI as a excel sheet. I created the visuals I need for it and after a week of daily refreshes I now keep getting this error message: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

 

Does anyone have a solution for this? I have tried copying the it in Edit Query and then renaming it. Once I did that I had to redo all the visuals and it still didn't work. I have even tried removing the Applied Steps in the edit query and I still receive the error message. If anyone has a solution that would be wonderful! 

 

Thanks!

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi asingh

     

    You could have a reference of  several solutions in this similar thread .

     

    Best  Regards,

    Cherry