Forum Discussion

cisaemp's avatar
cisaemp
Regular Visitor
3 years ago

There was an error when processing the data in the dataset from SharePoint

Hello!   I have a Power Bi report getting data from SharePoint.  Everything works fine in Power Bi Desktop, but this weekend the automatic refresh from Power Bi Service has an error when processing...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PBI_Queryous ,

I am not sure what you mean by that , please tell if you have any solution for this issue?

 

Thanks,

Ashish

PBI_Queryous's avatar
PBI_Queryous
Advocate I
2 years ago

Hiya Anonymous ,

Is this part of the M-code here, the first step created when connecting to a SharePoint List.

Note the part highlighted in yellow. By default, the "ViewMode"="Default", this is what I found to be causing the error. If you change it to "All". It returns "All" columns in SharePoint, and resolved the issue in my case.