Forum Discussion

Krunalbpatel's avatar
Krunalbpatel
Icon for Helper III rankHelper III
10 years ago
Solved

PowerBI report refresh issue when use sharepoint online list

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's avatar
    v-caliao-msft
    10 years ago

    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

     

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    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