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 power BI everythings OK and I see all the columns, but when I import the file, I lose few columns. Does anyone has any idea what should I do? As I said, im new to this and I don't have alot of experience.
Any help/advice would be appreciated.
Thanks!
5 Replies
can't help with advice on whether Sharepoint might be the culprit, but something you might try is converting the Excel data range into a Table (select the whole range of the data, Ctrl + t will convert it to a table).
Power BI will pick up the table on import and allow you to select it on the import dialogue.
Might be wirth a try.
Hi,
Please try to check your data format in Excel that whether is Table or not.
Here are Sharepoint limitations:
Hope this helps.
Best Regards,
Giotto Zhi
- Thanks for the advice, but I already have a table. It might be a problem with columns in the table.
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.
