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

[cisaemp]

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 the data in the dataset, See below:

Data source error: Expression.Error: The column '<ccon>ID' of the table wasn't found.. ID. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Jobs.
Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 5e5aef79-1a88-42a8-8616-de24ac636707
Request ID: f6e2f053-24e8-c5f7-4ae4-42f2a7a101d0
Time: 2023-08-15 16:11:50Z

Please any help!

[ashc_cool10]

@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]

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

[ashc_cool10]

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]

Hiya @ashc_cool10 ,

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.

[cisaemp]

I reviwed all the steps, but didn't find any error. Also, I refresh the tables in Power Bi Desktop succesfully. I deleted the dataset from Power Bi Service and republish, but the error still.

[PBI_Queryous]

Try this: https://community.fabric.microsoft.com/t5/Service/There-was-an-error-when-processing-the-data-in-the...