Forum Discussion
Advocate IError 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.
"FirstUniqueAncestorSecurableObject' column does not exist in the rowset. The 'FirstUniqueAncestorSecurableObject' column does not exist in the rowset."
They are both SharePoint lists Online. No changes has been made, the schedule refresh just suddenly "broke". ? any suggestions. If I open the report in the desktop tool the refresh is working fine for that source/report.
EDIT: seems to only affect connections that use "SharePoint" as connection/data source. I have other similar reports in the same tenant that use oData, and they work fine.
Seems to be working now.
- Reentering credentials did not help
- Renaming report, upload/republish and refresh workedTried 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.
17 Replies
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
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?
I am getting the exact same error. All my reports which use Sharepoint Online lists are failing. They have been working fine for montths. The issue started on Friday 24th June. They refresh fine in Power BI Desktop. Tried to publish them again but the same error appears.
Please can someone advise?
Thanks
I am getting exactly the same issue.
robynmcMicrosoft Employee
I am seeing the same issue and it just surfaced recently for me as well. I find that I can do a refresh and republish through the tool, but it kinda defeats the point. However it is the only workaround I have right now. Any thoughts on a fix?
RfladAnyone from the PowerBi team that could look into this issue? Quite time consuming having to refresh and upload a new version just to get updated data from SharePoint.
Eric_ZhangIs there any update on this by any chance? It's becoming difficult to refresh the reports manually daily.
Appears to have been fixed as my reports refreshed overnight today.
- Rflad
Still not working for me.
- Eric_Zhang
The error disappears as of now in my sideļ¼ can you try to re-enter the credential or just re-create a new report and try to refresh?
I am also having the same issue. I'm receiving the following error - The 'FirstUniqueAncestorSecurableObject" column does not exist in the row set. I have loaded the report several times with no resolution. Can someone with microsoft look into this?
