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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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