Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Microsoft Employee
Microsoft Employee

Error connecting to data files in SharePoint Online

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.



Not applicable

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.

Memorable Member
Memorable Member

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.

Frequent Visitor

Update your enterprise gateway, it works for me.

Not applicable

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


Can anyone help?

Regular Visitor

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

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

Community Support
Community Support

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.




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!

Microsoft Employee
Microsoft Employee

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.

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.

Microsoft Employee
Microsoft Employee

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


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


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


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.



Microsoft Employee
Microsoft Employee

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?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.