Forum Discussion
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...
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.
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.