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

  • rjhale's avatar
    rjhale
    Helper V
    8 years ago

    I'm seeing the same thing on my end.  I didn't make any changes that would cause the refreshes to start failing so suddenly. 

     

    I'm really frustrated that there is no recognition of this problem, and there is very little else I can do to troubleshoot the problem. 

    • gimpexe's avatar
      gimpexe
      Frequent Visitor
      8 years ago

      same error message here,

      I'm using to a powerquery excel workbook stored on a SharePoint Online document library, which queries data from a SharePoint Online List.

       

      Power BI service is using 'Connect, manage, and view Excel in Power BI' option to connect to the excel workbook.

       

      "Workbook refresh failed. See details for more information."

      Failed Connections:Query - CrossDockList
      Cluster URI:WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
      Activity ID:dece3336-6a80-4b13-9ebc-80a4e47f35b5
      Request ID:5c3ea775-0c48-4bea-8922-f3aa22ddbf3c
      Time:2018-05-16 16:18:35Z

       

       

      There is no data gateway in my refresh scenario.

  • 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!