Get data from SharePoint list, missing column

[JonasN]

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

[Kaviraj11]

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]

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]

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