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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tcotillo
New Member

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
Anonymous
Not applicable

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

Padmaja
New Member

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

Sorry the file size is aroun 14 MB.

v-haibl-msft
Employee
Employee

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.