Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
When importing data from a SharePoint Online list into Power BI,
the table headers appear as Field1, Field2, Field3... instead of showing their proper names.
The list itself has correct field names, so I’m not sure why this happens.
If anyone knows the cause and solution, your help would be greatly appreciated.
Solved! Go to Solution.
Hi @Billie
Thanks for Posting your query in Microsoft Forum Community.
As per your query Issue with Incorrect Field Names from SharePoint Lists in Power BI. where Power BI is displaying the internal names of the SharePoint list columns instead of their display names. This can happen due to how Power BI retrieves data from SharePoint. Here’s some alternative approach that may help resolve this issue:
Refresh Data Sources:
Check SharePoint Column Settings:
Clear Cache:
Ensure the Latest Power BI Desktop Version
Use OData Feed:
Check for Special Characters:
If you find this post helpful, please mark it as the accepted solution so other community members can easily find it. Your Kudos are also greatly appreciated!
Hi @Billie
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
hi @Billie
Just following up as we haven’t received a response to our previous message. We hope your issue has been resolved.
If the solution we provided has worked for you, kindly mark it as the accepted solution.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
Hi @Billie
Thanks for Posting your query in Microsoft Forum Community.
As per your query Issue with Incorrect Field Names from SharePoint Lists in Power BI. where Power BI is displaying the internal names of the SharePoint list columns instead of their display names. This can happen due to how Power BI retrieves data from SharePoint. Here’s some alternative approach that may help resolve this issue:
Refresh Data Sources:
Check SharePoint Column Settings:
Clear Cache:
Ensure the Latest Power BI Desktop Version
Use OData Feed:
Check for Special Characters:
If you find this post helpful, please mark it as the accepted solution so other community members can easily find it. Your Kudos are also greatly appreciated!
Hi @Billie
This issue often occurs because SharePoint lists with customized forms or columns created in older versions of SharePoint can return generic column names to Power BI. To fix this:
Check Original Column Names in SharePoint:
Use the OData Feed:
Refresh the Query in Power Query:
Recreate the Query if Necessary:
By retrieving the list through the OData feed rather than the default SharePoint connector, you can typically get the proper field names and avoid the generic Field1, Field2 labels.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!