Error connecting to data files in SharePoint Online

[Wastidium]

Long standing and previously working connections to files on SharePoint Online suddenly started throwing the following error:

"DataSource.Error: We couldn't parse OData response result. Error: The property 'DisableCommenting' does not exist on type 'SP.List'. Make sure to only use property names that are defined by the type."

Nothing has been changed on either the PBI or SharePoint end by me.

Looking for some clarity or if others are having similar issues.

thanks!

[Anonymous]

How do we get email notifications for these types of issues? My teammate that co-owns the dataset got a notification, however I did not.

[mike_honey]

This issue briefly occurred for me - seemingly every scheduled refresh involving SharePoint failed with the same error, in the 2-hour period to February 20, 2021 2:00 to 4:00 UTC. Then they all went back to refreshing fine without any action from me.

Regrettably, unexplained glitches that resolve themselves after a few hours are a fairly regular occurrence with the scheduled refresh service, perhaps every 2-3 months.  The only underlying cause I can think of is shoddy DevOps.

My standard reaction now is just to wait a while and hope they go away.

[MIGUELG]

Update your enterprise gateway, it works for me.

[Anonymous]

The same here, one of my Reports on PBI service started to get this error on each scheduled refresh from today.

Can anyone help?

[chriso97dev]

this just started happening for me overnight, is there an issue with an upgrade or version?

[moomarine]

Same issue for me also. Any admins going to answer this any time soon. Its effecting a very important dashboard in my business.

[v-eqin-msft]

Hi @Wastidium ,

There is a blog posts on how to work around this problem.Please check if this could help you a little.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Wastidium]

Hi Eyelyn9,

All my reports that were having this issue have stabilized and not presented with this issue since Monday afternoon. If I have further issues I will look to implement the code from the blog you referenced.

Thank you!

[bill_lalonde]

I was getting the same error on Sunday and Monday with two reports that are on Schedulded Refresh. But this morning both reports refreshed just fine. For what it's worth, no changes have been made to the files or connections between Power BI and SharePoint.

[Wastidium]

Hi Bill,

All my reports stabilized this morning as well. Hopefully whatever it was has been resolved and we won't need to worry about it after this weekend.

[niteenm]

Yes, getting exact same error from 2/13 6am but it's intermittent on PBI Service. Tried downgrading API version to 14 and it seems stable from desktop as well as datasets on PBI Service aren't failing to refresh.

Not sure if this is related to below

https://techcommunity.microsoft.com/t5/sharepoint/disable-comments-in-lists/m-p/1980665

but this old one seems to work by downgrading to version 14

https://community.powerbi.com/t5/Power-Query/Connecting-to-a-SharePoint-List-Office-365-error/m-p/88...

https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents

Even using "Auto" for version seems to be working, but it fails sometimes (but not as often as version 15).

let
Source = SharePoint.Files("https://your_sharepoint_address", [ApiVersion = 14])
...
...

But the question remains - why the working API version 15 (from several months) is breaking suddenly.

-Niteen

[Vijay_B]

Getting the same issue - long stanidng connections to Excel files in Sharepoint Online are not being loaded up with this issue starting 13th Feb. Can anyone help?