Dataset not updating -recent error

[andy88]

This issue has popped up recently and not sure how to solve this. I am getting this error when working on the desktop version sometimes, but when i viewed the dataset online it was missing and I am getting the same error message as a reason why the data is not refreshing. 

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

This has only started happening from yesterday. 

Can someone help. 

[taneja_lokesh]

Try This:

• Go to Edit queries
• Select Database table from sharepoint
• Click Advance Editor
• Change ApiVersion = 14 instead of 15.

[leed]

Guys, it seems that  I have resolved the problem!

-Go to Edit Query, clear all cache. Then Refresh All.

-After that, go on Clear Permission and re log in for this sharepoitn source.

-Close the Edit Query, click on Refresh All.

Best,

Dung Anh

[Debug_Bug]

-Where do you go to "clear all cache"? Is it the credentials you mean?

[leed]

@Debug_Bug File > Options > Clear Cache

[CIRVINE94]

Thanks very much - this looks to have fixed my issue

[Debug_Bug]

Even clearing the credentials does not seem to be a permanent solution. It works a few times for me, but not consistently.

I was wondering: Do you have row level security enabled on the list you receive errors on - because I do. I have not seen errors on the others...

[JoshuaHoward · Accepted solution]

It looks like this is possibly a known issue at the moment if you take a look at the status of PBI Service: https://powerbi.microsoft.com/en-us/support/

The status is: Some users may experience their Sharepoint list queries fail to refresh. Next update @ 8/9/2018 12:00 PDT

[andy88]

Hi, i have tried clearing cache on the query editor and on the data set and there is still the same error. 

Also the data set is still missing on the online version.

[leed]

My bad, I did a few actions actually though. I thought it was the cache clearing works.

I just tested it again, and I did go to Edit Query, Edit Source Permission, clearing it and sign in again ( The one of Sharepoint!)

LMK if it works for you.

Thanks!

Dung Anh

[leed]

Same on my side!

@Amanda

[Debug_Bug]

Same issue here.

[aflores]

Same here. Came this morning and my refresh failed. The PBI desktop is showing error at the "source", so no idea if it is a Sharepoint or PBI problem

[musasi77]

I also have same issue, there's no change at the report but the data refresh failed.

At the begining, refresh by Power BI desktop worked but now it has same issue,

I reset login credential both of desktop version and the website, so far no joy.

Thanks and regards,

[kumbol]

This is an issue for me since yesterday. Weirdly, it sometimes passes through. It's also an issue evident in both the Service and PowerQuery on the desktop. Seems completely random.

[CIRVINE94]

This error started happening for us yesterday as well. Seems to be affecting all of our reports from Power BI that pull data from Sharepoint.

[DannySimpson]

This started going wrong for me from yesterday... is it a PowerBI or SharePpoint issue?

[DannySimpson]

This started for me yesterday too... Is this PowerBI or SharePoint issue?