Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rflad
Advocate I
Advocate I

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

1 ACCEPTED SOLUTION

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.

View solution in original post

17 REPLIES 17
manz
Frequent Visitor

Appears to have been fixed as my reports refreshed overnight today.

Still not working for me.

@Rflad

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?

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.

I have the same problem...even though I did everything

I'm also having the same error on a dataset using a SharePoint list that has been working for months:

Data source error:The 'HasUniqueRoleAssignments' column does not exist in the rowset.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:af12d896-c66c-49a8-910c-9c3b37ecfc36
Request ID:31ae2671-3e24-0e44-bfbe-c4776e9d11d8
Time:2017-05-12 07:19:37Z

 

I've not managed to work around it. I've recreated the dataset and republished, but get the error as soon as I republish.

 

Regards, Tony

keithtownbu67
New Member

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?

I too have the same error on all mye reports.( They originate from the same SharePoint list)

Any news from Microsoft ?

Rflad
Advocate I
Advocate I

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

@Rflad

 

I've already escalated this problem internally and would post back if there comes any update.

Is there any update on this by any chance? It's becoming difficult to refresh the reports manually daily.

robynmc
Employee
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?

manz
Frequent Visitor

I am getting exactly the same issue.

manz
Frequent Visitor

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

Emmanuel
New Member

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

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors