Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SharePoint report fail

Hello guys, I have some issue, I have create a report with Excel online. The Excel file is on Sharepoint. I connect this datas and i changes formats. When i apply my power query no problem but when i want to refresh my report i have this error message : HRESULT : 0x8002005 (DISP_E_TYPEMISMATCH)) I just want to refresh my repport, Some one can explain what i do wrong please ? Best Regards,
Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    Based on your information, it seems that is a comman error message type mismatch, I cannot see something specific in it as I'm not clear about your quey.

    The Excel file is on Sharepoint. I connect this datas and i changes formats. 

    I'm afraid that may caused by the changed formats. 

     

    By research, here is a similar thread which including some suggestions which may help you. You could have a reference of it.

     

    • Solved it by duplicating my table in the Query Editor, deleting the original table and renaming the copy to the original's name..
    • Figured out that if i remove all the relations to the table it will be better to do changes on it.
    • Removed the relations and edited the table (without duplicating it and etc.), all the changes were applied without any problems.



    Best  Regards,

    Cherry