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, have small data models, and were previously being refreshed from the Power BI Service on a schedule. This had been working without any issues up until last Friday (5/11) when the scheduled refreshes started failing even though the data gateway is healthy, and I'm not finding anything that stands out in the log files. I'm seeing really generic errors in the service that look like this with 15+ scheduled data refreshes:
| Failed Connections: | Query - Get Award Exceptions |
| Cluster URI: | WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net |
| Activity ID: | e8c3cc55-01e2-4f85-647a-60d8643ac60f |
| Request ID: | a79a6fd5-f59b-61d1-2a16-2bd8c6f098a1 |
| Time: | 2018-05-14 14:25:15Z |
I went as far as reinstalling the data gateway (I only have one machine with the enterprise gateway installed) and republishing several of my reports. The on-demand refreshes would typically complete a refresh successfully the first time, but now they are right back to failing with the generic errors such as the one above. This is becoming a very big problem for us as this is now day 5 of all our scheduled processes being down.
I'm wondering if there is something wrong with the Power BI service or has there been a change on how the refresh functionality works for Excel workbooks?
