Forum Discussion

JonasN's avatar
JonasN
Frequent Visitor
2 years ago

Get data from SharePoint list, missing column

Hi!

 

I'm having a report that gets data from a SharePoint list. Everything is working fine when using my own account.
But when changing to another service account (read permissions on the SharePoint site) and refresh the model, it's missing one column (the one I need).
I have tried to logon directly to SharePoint with the service account, and I can see all columns in the list.

 

Why is the column disappearing when using the service account?

 

/Jonas

Need Help

3 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Hi,

     

    Even though the service account has read permissions, ensure that it has the necessary permissions for all relevant content types and hidden lists that might be associated with the column in question.

    • JonasN's avatar
      JonasN
      Frequent Visitor
      2 years ago

      But if I login with the service account in SharePoint, I can see all columns, but when fetching the data from Power BI a single column is missing. So I don't think this is a permission issue.

      • Kaviraj11's avatar
        Kaviraj11
        Solution Sage
        2 years ago

        Is it a List? because you would be able to expand the columns, could it be hidden under those column?