Columns missing from imported Excel data

[timprevodnik]

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!

[Anonymous]

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? 🤷‍♀️

[Perathara]

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. 

[timprevodnik]

Thanks for the advice, but I already have a table. It might be a problem with columns in the table.

[v-gizhi-msft]

Hi,

Please try to check your data format in Excel that whether is Table or not.

Here are Sharepoint limitations:

https://docs.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description... 

Hope this helps.

Best Regards,

Giotto Zhi

[PaulDBrown]

@timprevodnik 

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.