topic Re: Data not refreshing in Power Query

Data not refreshing

jasonlosser — Wed, 12 Aug 2015 18:37:39 GMT

My service has been running fine for a week. Now, as of 2 hours ago, all my reports are failing to refresh, stating my 'personal gateway is offline'. Yet, it is not offline. The drop-down menu says it is online, as well as I physically ensured it is still running. What is happening?

Re: Data not refreshing

Greg_Deckler — Wed, 12 Aug 2015 19:02:18 GMT

Best guess is that whatever heartbeat is used to ensure that it is online is failing. I've seen this once and rebooting/restarting gateway seemed to clear it up. Your mileage may vary.

Re: Data not refreshing

jasonlosser — Wed, 12 Aug 2015 19:08:56 GMT

Unfortunately, I've re-booted the gateway and nothing has changed.

All the files that are .pbix files and in 'MyWorkplace' are working fine; it's the Excel-type files in my workgroups that all have ceased operations.

So, the Gateway is working for some files, but not all. No clue how to fix this. And, no idea how I am supposed to convince users that this is a stable system.

Re: Data not refreshing

Greg_Deckler — Wed, 12 Aug 2015 19:12:40 GMT

Ah, that's interesting that it thinks the gateway is online for some data sources and not for others. Any connectivity issues between your gateway and those Excel files?

Sorry, that last question does not apply if you are referring to Excel files uploaded to the service.

Re: Data not refreshing

jasonlosser — Wed, 12 Aug 2015 19:16:21 GMT

The most troubling aspect is that the files were updating fine for a week, and then just 'ceased'.

As luck would have it, I conducted a call regarding migrating to the new service from the 'old' PowerBI platform and touted the reliability we will see. OUCH. Now I sit and wait to see if the service will work tomorrow.

Re: Data not refreshing

jasonlosser — Fri, 14 Aug 2015 13:45:25 GMT

Anything on this from the MSFT people ?????

Re: Data not refreshing

jasonlosser — Fri, 14 Aug 2015 13:49:36 GMT

Here is the part that bothers me...my error is 'on-premises Gateway is offline'. However, the next section then confirms my gateway IS online.