PowerBI report refresh issue when use sharepoint online list

[Krunalbpatel]

i have created report from sharepoint online list it's working properly but when i update list data and refresh the report it shows me following error.

Something went wrong.

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Processing errorThe 'FirstUniqueAncestorSecurableObject' column does not exist in the rowset.
Cluster URIWABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

[v-caliao-msft · Accepted solution]

@Krunalbpatel

Would you please share about how you connect to SharePoint Online here?

Regarding refresh, if you have already published the report to Power BI Service, could you please share about how you configured the Refresh settings, especially for the Gateway and the Data source Credentials?

If possible, please take a try to connect to another SharePoint Online List, then publish it again, after that, verify to see if issue insists.

The error message told that 'FirstUniqueAncestorSecurableObject' column does not exist in the rowset, which I suspect the permission hierarchy set on the SharePoint online list might be changed. Please verify it, or contact the SharePoint Online admin.

In addition, we may also take use of Fiddler and see if we could have any further helpful information from the HTTP trace. Once captured, please consider upload it into OneDrive, then post the shared link here, we will help to take a further look.

Regards,

Charlie Liao