Forum Discussion
There was an error when processing the data in the dataset from SharePoint
This same problem started for us on Friday evening as well. The ID column is there in the SharePoint Online list, it is there in the data after the import, and any refresh done of the dataset in the desktop app works successfully. However, after publishing the dataset to our workspace the refreshes fail with the error mentioned above.
Advocate II'm having the same problem. PBI Service is lying to us. The ID column exists, and PBI Desktop refresh works fine. The PBI Service claims it can't find the ID column, even though this column isn't referenced in the M-code.
This is definitely a MSFT bug.
- PBI_Queryous
Thanks aj1973 -
It seem's you need to change the ViewMode to "All" instead of "Default".
Also - you MUST select the ID column, for some reason it doesn't let you unselect this column. I don't recall this being a limitation before?
Kindest regards,
PBI Queryous 
Hi aj1973
i am facing the same issue. Untill Friday in PB Service my refreshes were happeing but suddenly it stopped working. I have report with two data source(SAP HANA and SharePoint-file is in csv).
My data set is getting refreshed in Desktop however when i am trying to refresh this in service i am getting below mentioned error.
I have checked all the security is "Organisation" in both of the data source . Please help if you have any idea.
