Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
JonasN
Frequent Visitor

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

3 REPLIES 3
Kaviraj11
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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.

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.