Forum Discussion

manuel_zwoelfer's avatar
manuel_zwoelfer
New Member
9 years ago
Solved

Error get Data from Sharepoint Online "HasUniqueRoleAssignments"

We have currently troubles to sync Data from Sharepoint Online via on-Premises Datagateway.

Datagateway and PowerBI Desktop installed in the newest version.

 

Following Error appears:

Fehler bei der DatenquelleThe 'HasUniqueRoleAssignments' column does not exist in the rowset.
Cluster-URIWABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Aktivitäts-IDae80dc9a-8335-4790-a571-6b6c573d28cb
Anforderungs-ID5e7f9796-896d-c26f-7c8d-c5cf85e719d9
Zeit2017-05-12 08:13:59Z
 
We tryed to delete the Dataset, and Upload it again. With the same Result.
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi manuel_zwoelfer,

    This issue has been submitted internally to Power BI team and the team is working on it. The workaround for this issue is to avoid using “Remove Columns” and instead use “Remove Other Columns” in the UI to remove all but the bare minimum of columns that you need for your data model.

    Thanks,
    Lydia Zhang

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi manuel_zwoelfer,

    This issue has been submitted internally to Power BI team and the team is working on it. The workaround for this issue is to avoid using “Remove Columns” and instead use “Remove Other Columns” in the UI to remove all but the bare minimum of columns that you need for your data model.

    Thanks,
    Lydia Zhang

    • mzikra's avatar
      mzikra
      Icon for Advocate II rankAdvocate II

      When using this method of "Remove Other Columns" i recive the error - "Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host." in a test report i just published to try this method.  

       

      I have 12 lists with over 30 columns in each that are needed for my modeling connected via SP Online.  This is not a very good solution that seems to not work for me.  Anyone have success with this method? 

       

      Again, another error i did not previously receive before the may release. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello Team, 

     

    I still have the issue when refreshing from a sharepoint online list. Upgrades and the commented workarounds have not resolved my issue.  The option of developing my query from scratch is not an option as the query is huge.... :(

     

    Any suggestion please? I´m really frustrated

     

    Thanks