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
3 years ago

aj1973 i did that. I referenced my query in PQ and applied the steps again and then mergerd my reference requery with SAP HANA Query but again same errot in PBI Service.

 

Not sure whats wrong with this.

 

Regards,

Ashish

PBI_Queryous's avatar
PBI_Queryous
Advocate I
3 years ago

Theres a bug in the SharePoint 2.0 connector, and how it reads views "Default" and "All"

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 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.