Forum Discussion
Excel Workbook and Gateway
I have an Excel document that connects to a DB on my private network using Power Query to bring data into a worksheet and the Excel data model. I have placed this document in my Onedrive for Business and have "connected" to it from within PowerBi. I was under the impression that once I did this I should be able to go into the ScheduleRefresh section of the workbook in PowerBi and connect it to my Gateway and once I manually refreshed it the excel workbook in my OneDrive would be updated with fresh data from the database. First, is this the way it SHOULD happen? Secondly, why do I keep receiving the following error that is utterly useless as most are from MS.
Last refresh failed: Tue May 15 2018 08:25:09 GMT-0600 (Mountain Daylight Time)
Workbook refresh failed. See details for more information.Hide details
| Failed Connections: | Query - Query1 |
| Cluster URI: | WABI-WEST-US-redirect.analysis.windows.net |
| Activity ID: | 8846b6c0-68e0-4266-ab2b-0b95ede3e6b6 |
| Request ID: | f5cc88a7-d2d1-a482-97ad-3e7f72af3428 |
| Time: | 2018-05-15 14:25:09Z |
7 Replies
Well, it appears that this is due to a service outage that has been in place since 5/12. Ridiculous how MS cant provide better error messages than they do.
I agree. The acknowledgement of this outage took way too long. I'm happy to see it's finally up on the status page:
Geez...how long is it going to take to fix this...still nothing and we are on day 4 contrary to when they actually announced the issue.
