Forum Discussion

Fern_21's avatar
Fern_21
Helper V
2 years ago
Solved

Power BI doesn't import All Records from SharePoint List with Item-level Permissions

Hi all,   I have a SharePoint list with Item-level Permissions; in this way, each user can only interact with their own records. The owner of the Sharepoint list has full control on it and he is ab...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi all,

    Update:
        SharePoint team applied the mitigation, and the issue has been resolved.

    Please check. If there are still issues, please feel free to contact me.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group

christinepayton's avatar
christinepayton
Most Valuable Professional
2 years ago

Hmm you scared me for a second so I went back and checked some of my reports where I use this same feature and they are all still working normally. Are you sure that the account you are using has full control permission on the list? I'm not familiar with "cancel checkout" in the way you mention, but full control permission should bypass the item-level permissions. 

 

  • Fern_21's avatar
    Fern_21
    Helper V
    2 years ago

    I didn't have any problems for three years and I have full control permission on the list. 
    On Sharepoint it is ok, but on Power BI I have this problem now.

     

     

    • ag_93's avatar
      ag_93
      New Member
      2 years ago

      I have the same problem. Has anyone solved it?

      jasonwhowell 

      • nicolasimeoni's avatar
        nicolasimeoni
        New Member
        2 years ago

        I have the same problem. Tried with Sharepoint Online List 1.0 and 2.0 connector. I only see items creatyed by me. The problem started yesterday.  Both in Power BI Desktop and Power BI Service

    • christinepayton's avatar
      christinepayton
      Most Valuable Professional
      2 years ago

      Are you using the 2.0 or 1.0 connector? 

      • Fern_21's avatar
        Fern_21
        Helper V
        2 years ago

        I'm using Sharepoint list. I also tried using both Sharepoint Online List 1.0 and 2.0 but I didn't fix the problem yet.