PowerBI cannot connect to a workbook stored in "SharePoint - Team Sites"

[bmoles]

The PowerBI service cannot add (connect) an Excel workbook which has a PowerPivot model that pulls data from an Azure SQL database. The spreadsheet is stored in a "SharePoint - Team Site" (in Office 365).

The error information is:

We couldn't connect to your workbook from Sharepoint - Team Sites

The last refresh attempt failed because of an internal service error.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID3db82305-1bab-44cc-a563-f8be93142cb6
Request IDbe8263b4-4b66-602f-dd31-892ecb3ee059
Correlation IDc342e77e-7bd8-20b6-7e81-0ba32944202d
Status code500
TimeWed May 10 2017 17:08:53 GMT+0200 (Romance Daylight Time)
Version13.0.1700.2027
Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net

 This workbook is a copy of another one that is already in PowerBI. The difference between both copies is that the new one (the one with the issue) is connected to an Azure SQL database while the original one (the one tha was already on PowerBI) is connected to a SQL Server instance hosted in a VM within Azure.

We have reviewed the connection string of the affected spreadsheet and it is similar to other reports that we have created before for other clients in other subscriptions. We cannot see any difference (other than server name and credentials.

In this case, as we are connecting to an Azure SQL database there is no need of Datagateway.

Any help will be appreciated.

Kind Regards,

Ben

[bmoles · Accepted solution]

Hi @v-qiuyu-msft,

Thanks for your answer. This is the first time I had this issue. I just tried this morning and it worked as expected. It may have been caused by a temporary issue in the service. We experienced other issues with Yammer yesterday as well. Not sure if they may have been related.

In any case, it seems to be solved.

Thanks again.

Regards,

Ben

[v-qiuyu-msft]

Hi @bmoles,

Does this issue occur frequently? Please use Refresh Now to refresh the workbook to see if the same error occur. If issue persists, please run teh Fiddler then repeat refresh to capture trace, share .saz file with us.

Best Regards,
Qiuyun Yu

[bmoles · Accepted solution]

Hi @v-qiuyu-msft,

Thanks for your answer. This is the first time I had this issue. I just tried this morning and it worked as expected. It may have been caused by a temporary issue in the service. We experienced other issues with Yammer yesterday as well. Not sure if they may have been related.

In any case, it seems to be solved.

Thanks again.

Regards,

Ben

[v-qiuyu-msft · Accepted solution]

Hi @bmoles,

From your description, it seems that the issue is gone now. If it is, would you please mark a helpful reply as an answer so that we can close this thread? If the issue occur next time, please create a new thread.

Best Regards,
Qiuyun Yu