cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tcotillo Occasional Visitor
Occasional Visitor

Unable to connect to Excel in OneDrive through Power BI

When I try to connect to an Excel file in onedrive, I experience the error below.  I am logged into Onedrive and Power BI with the same account.  Other people in the organization are about to connect to this Onedrive instance from their versions of Power BI.

 

Has anyone else experienced this:

 

This is the error message I am getting.

 

Capture.JPG

4 REPLIES 4
v-haibl-msft Super Contributor
Super Contributor

Re: Unable to connect to Excel in OneDrive through Power BI

@tcotillo

 

I just tried to import data from OneDrive - Business on PBI Service according to the steps in this document. Everything works well in my side. Is there any special item in your excel file? You can try with a simple excel file which only includes a few data to see whether it is related to your excel file or PBI Service itself.

 

Best Regards,

Herbert

Padmaja Frequent Visitor
Frequent Visitor

Re: Unable to connect to Excel in OneDrive through Power BI

I am also getting a similar error. I am using Power Pivot in the excel and the size of the file is 1.5 MB .  Has it got anything to do with file size.  Below is the error I get.

Failed to configure selected file
Please try again later or contact support. If you contact support, please provide these details.

Activity ID71e221ca-e5fa-4a56-b1c0-46509de240c1
Request IDef8da3ad-64ae-7525-31ec-1cf437c5629d
Correlation IDc9e2a5ef-1a11-eeec-4fd4-ba4c13ff1d5a
Status code400
TimeFri Feb 03 2017 10:34:06 GMT+0530 (India Standard Time)
Version13.0.1700.1121
Padmaja Frequent Visitor
Frequent Visitor

Re: Unable to connect to Excel in OneDrive through Power BI

Sorry the file size is aroun 14 MB.

rbalakr4 Frequent Visitor
Frequent Visitor

Re: Unable to connect to Excel in OneDrive through Power BI

Hi,

Even am not able to connect to a dataset in excel through one drive and I am getting the below error

 

Something went wrong
Failed to configure selected file
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 1e7a639d-4fa6-4d24-bd37-73fa8723cad0
Request ID: d42fc787-12fc-e6fe-327f-175d22860316
Correlation ID: d01ce76e-15a6-a795-90bb-4a0ee3a4b486
Status code: 400
Time: Sat Feb 16 2019 14:33:03 GMT-0500 (Eastern Standard Time)
Version: 13.0.8383.201
Cluster URI: https://wabi-us-east-a-primary-redirect.analysis.windows.net