Forum Discussion
Columns missing from imported Excel data
Hi I've been around the internet trying to find the solution for days now. I'm new to power BI, so it might be stupidly easy but anyway. I have Excel file on Sharepoint. If I connect it with ...
I had the same problem just now. I changed the name of the missing column name in the Query that I used to create the table in Excel (data from one sheet using Power Query to create a table in another sheet) and saved the file back to SharePoint. After refreshing everything, my column is now showing up in Power BI. I guess it just hated my column name? 🤷♀️
Yes, looks like a header length issue - name in the column header. Had a similar issue, and when i reduced the column header name, the BI tool reflected all columns which were previolsy not shown.
