Forum Discussion

Rflad's avatar
Rflad
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Error auto refresh SP Online lists (Canceled by user / FirstUniqueAncestorSecurableObject) ?

I got two reports that have been working for 6 months or so, no I am getting either "canceled by user" or the below error when trying to use the schedule update option for these reports.    "FirstU...
Need Help
  • Rflad's avatar
    Rflad
    10 years ago

    Seems to be working now.
    - Reentering credentials did not help
    - Renaming report, upload/republish and refresh worked

     

    Tried that as well yesterday but today at least it worked.

    Thanks :-)

     

    PS: a small minus is that you have to recreate all "links" in your dashboards since the old reports don't work anymore.

Emmanuel's avatar
Emmanuel
New Member
10 years ago

Hello

i hae exactly the same issue "The 'FirstUniqueAncestorSecurableObject' column does not exist in the rowset"

the refresh worked perfectly before but now no way.

regards

manz's avatar
manz
Frequent Visitor
10 years ago

I am experiencing the exact same problem - and the issue only appears to be with Sharepoint Online Lists. Started on Friday 24th June. Refresh works fine in Power BI Desktop. Tried to publish again but same problem. Anyone any ideas?