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

Re: Dataset not updating -recent error

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

leed Regular Visitor
Regular Visitor

Re: Dataset not updating -recent error

@Debug_Bug File > Options > Clear Cache

taneja_lokesh Frequent Visitor
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
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 Regular Visitor
Regular Visitor

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

Re: Dataset not updating -recent error

Thanks very much - this looks to have fixed my issue

Highlighted
Debug_Bug Frequent Visitor
Frequent 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 Frequent Visitor
Frequent Visitor

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
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 325 members 3,161 guests
Please welcome our newest community members: