Forum Discussion

rjhale's avatar
rjhale
Helper V
8 years ago

Excel Workbook Refresh Fails in BI Service

I have seen several other replies on issues about this same topic, but nothing specifically for the problem I'm about to describe:   I have several Excel workbooks that are hosted in SharePoint, ha...
Need Help
bhagchandani's avatar
bhagchandani
New Member
8 years ago

Both Schedule and on demand refreshes for Excel Workbooks are failings since saturday 05/12/2018

and now the refreshes are disabled.

 

Dont understand what Microsoft is doing.

 
Although Power BI refreshes(using PBIX) are working fine and the gateway does not log any message either.

 

Below is the message which I am getting, it is not at all descriptive.


Scheduled 5/14/2018, 9:31:06 AM 5/14/2018, 9:34:21 AM Failed Workbook refresh failed. See details for more information.
Failed Connections: XXXX
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 89899023-b67d-480b-a29c-de10c2e1aacc

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I am getting the same issue!!  Started May 11.   Auto refresh used to work. (It worked May 10).  Now I have extra work. Not happy.  One of the errors mentioned something about being created in Excel 2013 and no longer supported.  I rewrote workbook and made new connection with Excel 2016--same problem no refresh: on demand or scheduled.
On prem data gateway says admin has granted access for credentials. 


What changed May 10/11?  What is the correct way to make a connection or configure gateway now?

 

One Error Msg:
You can't schedule refresh for this dataset because one or more sources currently don't support refresh.
Discover Data Sources

Connection was SqlServer to Azure DB

  • uhlig's avatar
    uhlig
    Frequent Visitor
    8 years ago
    Same on my side and no response from support on my ticket since days!