Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0

Error - Status Code 500- We couldn't import data from Excel Workbook

power bi error2.PNGpower bi error.PNG

Status: Delivered
Comments
v-yuezhe-msft
Microsoft Employee

@tmaccurdy,

I have no issues importing data from Excel file into Power BI Service. In your scenario, please ensure that you transform the data in your Excel file into table fomat as shown below. Then import data again to Power BI Service.
1.PNG

In addition, you can use Excel connector in Power BI Desktop to connect to Excel files, create report in Power  BI Desktop and publish the report to Power BI Service.

Regards,
Lydia

v-yuezhe-msft
Microsoft Employee
Status changed to: Delivered