Power BI Issue

[RobinPowerBI]

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?

[v-cherch-msft]

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

[RobinPowerBI]

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

[RobinPowerBI]

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?

[v-cherch-msft]

Hi @RobinPowerBI

It seems you may try to Pin the spreadsheet to dashboard. Then share the dashboard with others. Here is the reference for you. If you have any concern on the feature, you can submit your idea here.

https://docs.microsoft.com/en-us/power-bi/service-how-to-collaborate-distribute-dashboards-reports

Regards,

Cherie