Forum Discussion
Can't load excel file in Power BI Web.
I followed the steps on how to create a data set fromj an Excel file with no success. I tried different tabular Excel files to load, I get a message says importing file , however that message qui...
WillT
Community Admin
Community AdminHi - is the data in your workbook marked as a table? Or in the Excel data model? Those are the best ways to get Power BI to detect the data. You could also try uploading the workbook to OneDrive first and connecting from there.
There are details here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-from-excel-to-stunning-report/
Let us know how you get on.
Will
Same problem. Creating a table works (also got it to work as a CSV). But why does one have to create a table? That's an extra step and I am used to microsoft products knowing from the data when a worksheet is formed as a table, or how to find the contiguous region.