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|
I agree. The acknowledgement of this outage took way too long. I'm happy to see it's finally up on the status page:
Microsoft just updated their status page with this:
Some users may have experience problems with refreshing their excel online workbooks with on-prem data. Engineers are aware of the issue and are working on a fix. Next Update @05/21/2018 14:00 PDT.
Really? We have to wait another 5 days just to get an update? This service does not seem to be production-ready.
Here we are...Monday morning. 5 days after they actually declared this an issue and one week since it really was an issue and it's still broken. I put in a ticket but the incompetence of the support people and their inability to communicate with me made that a waste of time. Seems that this functionality should be listed as BETA rather than production ready. I can't imagine the folks that are truly depending on this capability.
Received another update last night from Microsoft stating that the fix was validated in their test env and it would begin rolling out. Should be fully deployed by Thursday. Yay...it only took Microsoft 10 days to get this fix deployed. Well, we will wait and see if it really does in fact happen that way. I am SOOOO glad that Microsoft is focusing on all the worthless crap they are like being able to view Org Charts through VR Goggles on Sharepoint rather than fixing the products their customers already pay for. Wow...mind blown!
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!