Not importing SharePoint List Headers

[StuartSmith]

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?

[MattBH]

I always have this issue when importing an excel table into SP list then connecting via BI.

[StuartSmith · Accepted solution]

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.

[v-rongtiep-msft]

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.