cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Debug_Bug
Regular Visitor

Re: Dataset not updating -recent error

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

Highlighted
leed Advocate II
Advocate II

Re: Dataset not updating -recent error

@Debug_Bug File > Options > Clear Cache

taneja_lokesh
Frequent Visitor

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.
andy88
Frequent Visitor

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.

leed Advocate II
Advocate II

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

CIRVINE94
Frequent Visitor

Re: Dataset not updating -recent error

Thanks very much - this looks to have fixed my issue

Debug_Bug
Regular Visitor

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

JoshuaHoward Advocate I
Advocate I

Re: Dataset not updating -recent error

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

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.