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 ...
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.