Forum Discussion
Power ParticipantNot importing SharePoint List Headers
I have some sharepoint lists and when importing them into Bi, the headers are not importing and therefore unable to promote headers and have to manually rename the columns. Any ideas why?
Unfortunately, neather of the above links helped and in the end, I ended up renaming the column headers from "field1", etc. to the desired column name.
6 Replies
Hi StuartSmith ,
Whether in your sharepoint list contains "lookup" value?If not,try below steps:
After successfully connecting with power bi>transform:
Move to right side of lines>expand:
Here is the reference: Use SharePoint Online List As A Data Source In Power BI (c-sharpcorner.com)
check if this helps.
I have also found a similar post, please refer to it to see if it helps you.
Solved: SharePoint Column Names Appear Corrupted When Impo... - Microsoft Power BI Community
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I always have this issue when importing an excel table into SP list then connecting via BI.
Thanks. This just explained the issue to me. When we create from Excel, the native fields are field_1, field_2 etc and the field name added during list creation process is just a label. Power BI fetches the internal field names. Too bad. To check if this is the case with you, go to List settings, click on the column, and read the name that shows in address bar.
StuartSmithUnfortunately, neather of the above links helped and in the end, I ended up renaming the column headers from "field1", etc. to the desired column name.
MattBH made a comment which helped me figure out why this happens. When we create SharePoint list from Excel, the native/internal fields are field_1, field_2 etc and the field name added during list creation process is just a label. Power BI fetches the internal field names. Too bad SharePoint doesn't use field names from Excel as internal field names, allowing us to edit them if needed. To check if this is the case with you, go to List settings, click on the column, and read the name that shows in address bar.
Make sure to select SharePoint Online List from within PowerBI/Query Editor 'new source' options (see below photos).
After selecting your SharePoint list, click OK to load data.
You should now see the headers formatted properly in your table.
