Forum Discussion

andy88's avatar
andy88
Frequent Visitor
8 years ago
Solved

Dataset not updating -recent error

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 g...
General Comment
  • JoshuaHoward's avatar
    JoshuaHoward
    8 years ago

    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

leed's avatar
leed
Advocate II
8 years ago

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's avatar
Debug_Bug
Regular Visitor
8 years ago

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

  • leed's avatar
    leed
    Advocate II
    8 years ago

    Debug_Bug File > Options > Clear Cache

    • andy88's avatar
      andy88
      Frequent Visitor
      8 years ago

      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's avatar
        leed
        Advocate II
        8 years ago

        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's avatar
      CIRVINE94
      Frequent Visitor
      8 years ago

      Thanks very much - this looks to have fixed my issue

      • Debug_Bug's avatar
        Debug_Bug
        Regular Visitor
        8 years ago

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