We couldn't connect to your workbook from OneDrive - Business

[IoT]

I have an data model from PowerPivot in Excel that I used to create a report in PowerBI (Desktop)

My workbook is saved on my One Drive, but when I added measures/updated the Data Model in excel the connections to PowerBI broke.  Based on this article I need to upload to the web version of PowerBI and select "Connect, Manage and View Excel in PowerBI" to allow a live link between the two Data Models. When I tried to do that I got this error:

...

We couldn't connect to your workbook from OneDrive - Business

Power BI couldn't connect to this workbook. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.

We couldn't connect to your workbook from OneDrive - Business

Power BI couldn't connect to this workbook. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.

Activity IDafd36ae8-4f1d-4536-88ff-465b85fcf105

Request ID2dede169-eaa5-bae8-0bfa-dbd6ed365122

Correlation IDf975c68b-a75f-94d2-bd48-8228d71f8e0f

Status code400

TimeFri May 26 2017 09:55:00 GMT-0400 (Eastern Daylight Time)

Version13.0.1700.2227

Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net

[v-shex-msft]

Hi @IoT,

I test with normal excel file(onedrive) without any issue, so I think your data models are from other data sources, right? It may caused the issue.

Regards,

Xiaoxin Sheng

[IoT · Accepted solution]

Most of the tables in my data model are uploaded from tables in Excel. I do have some tables that pull through Power Query from SalesForce, but I've done the exact same thing in PowerBI without issue.

The workaround I used was publishing my workbook (in Excel) to Office365. This doesn't maintain a live link, but I can refresh in PowerBI (online) and the data model updates.