Reply
Frequent Visitor
Posts: 6
Registered: ‎08-09-2018

Re: Dataset not updating -recent error

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

Regular Visitor
Posts: 22
Registered: ‎08-24-2017

Re: Dataset not updating -recent error

@Debug_Bug File > Options > Clear Cache

Frequent Visitor
Posts: 6
Registered: ‎08-09-2018

Re: Dataset not updating -recent error

Try This:

 

  • Go to Edit queries
  • Select Database table from sharepoint
  • Click Advance Editor
  • Change ApiVersion = 14 instead of 15.
Frequent Visitor
Posts: 6
Registered: ‎06-04-2018

Re: Dataset not updating -recent error

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.

Highlighted
Regular Visitor
Posts: 22
Registered: ‎08-24-2017

Re: Dataset not updating -recent error

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

Frequent Visitor
Posts: 2
Registered: ‎08-09-2018

Re: Dataset not updating -recent error

[ Edited ]

Thanks very much - this looks to have fixed my issue

Frequent Visitor
Posts: 6
Registered: ‎08-09-2018

Re: Dataset not updating -recent error

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...

Frequent Visitor
Posts: 4
Registered: ‎10-16-2017

Re: Dataset not updating -recent error

[ Edited ]

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