Cannot import data from excel file to online Power BI

[cbusila]

I have created a data model in excel and I want to create a dataset in Power BI (online) and when I try to import data I get the folowing error: We couldn't import data from Excel Workbook and the below technical details.

Activity IDdb8ba327-cb7c-bc58-3367-9b2814cb4c07

Request IDdcdb1801-95eb-e8e5-50ab-0691de6ac9c3

Correlation ID47ecb293-0b4d-cc95-1e10-4ea82c06f4e9

Status code500

TimeTue Apr 03 2018 04:13:26 GMT+0300 (GTB Summer Time)

Version13.0.4898.154

Cluster URIhttps://wabi-west-europe-redirect.analysis.windows.net

Please help me understand what can I do to solve the issue.

[v-juanli-msft]

Hi @cbusila

I can’t reproduce the issue. Does this happen all the time for all excel files? Please try to connect to other excel files with small size to see if the size of excel and data model caused the issue.

Also, please try to import the workbook in Power BI Desktop. Then publish onto Power BI Service to see if it works.

Best Regards

Maggie