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 ...
Need Help
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