Forum Discussion
Power BI Issue
I am trying to link a spreadsheet to Power BI, the Excel sheet is a table format and held on OneDrive for Business.
My process:
- Get Data in Power BI
- Create New Content
- File/Get
- OneDrive – Business
- Choose File
- Connect
- Import Excel data into Power BI
Then I get this 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: 39189ac1-4cbc-4875-b22c-ae588fef411c
Request ID: f4a22a14-7974-e0ab-320c-5730288c839f
Correlation ID: 9da963b5-d57c-f6ca-5702-ef24505737af
Status code: 400
Time: Thu Sep 20 2018 21:32:26 GMT+0100 (British Summer Time)
Version: 13.0.6700.191
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
Please help?
4 Replies
Hi RobinPowerBI
Based on my test, I cannot reporduce the same issue. Please refer to the documnets Connect to files stored in OneDrive for your Power BI app workspace and Get data from Excel workbook files. It seems you may try to check the size of the excel. Here is the reference for you: Reduce the size of an Excel workbook to view it in Power BI. If it is not your case, you may submit a support ticket.
https://powerbi.microsoft.com/en-us/support/
Regards,
Cherie
- Hello, the file is less than 1MB. I cleared all formatting and comments and hyperlinks from the spreadsheet and this now works. The spreadsheet is collaboratively used in globally offices so I will need to set rules as Power BI seems not to accept these functions, maybe MS can look into this for future releases? Thanks for your help
I am trying to link a spreadsheet to Power BI, the Excel sheet is in a table format and held on OneDrive for Business.
I have successfully linked many time before.
My process:
- Get Data in Power BI
- Create New Content
- File/Get
- OneDrive – Business
- Choose File
- Connect
- Import Excel data into Power BI
Then I get this 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: 39189ac1-4cbc-4875-b22c-ae588fef411c
Request ID: f4a22a14-7974-e0ab-320c-5730288c839f
Correlation ID: 9da963b5-d57c-f6ca-5702-ef24505737af
Status code: 400
Time: Thu Sep 20 2018 21:32:26 GMT+0100 (British Summer Time)
Version: 13.0.6700.191
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
Please help?
