Weird gateway issue "There is no available gateway." but all sources checked and double checked

[djk1000]

Hi,

So this is a wierd issue, I have a  report  that had been on scheduled refresh without issue, in the last couple of days if I change the schedule I get the "Install personal gateway" message and I can't schedule the refresh on the enterprise gateway.  I've double checked the sources and they are all in the enterprise gateway and seem to be connected.

I opened a new blank pbix in desktop and created connections to the same sources (copy paste the sources from the problem report), deployed it and I was able to schedule the refresh.

I'm hoping there is no corruption in the report .pbix causing this. 

I unsderstand that this is very general but I'm wondering if anyone has had a similar issue or failing that, could someone suggest next steps for tracking down the bug?

I'm using the latest version of PowerBI desktop and the enterprise gateway was updated to the latest version at the end of September.

Thanks!

[djk1000 · Accepted solution]

It looks like an issue others are having too,

https://community.powerbi.com/t5/Issues/Gateway-disabled/idi-p/268213/page/2#comments

[v-huizhn-msft]

Hi @djk1000,

You said that had been on scheduled refresh without issue, you add the data source in old gateway version, right? If it is, you create a new pbix file, it works fine, which mean the lastest dataway support the datasource, so I guess there is a problem between old and new gateway version. You can Fiddler to trace what is happening between your client machine and the Power BI Service like shown in the vedio. Then please create a support ticket on the right bottom of this page, share the traced logs to them to get better assistance.

Best Regards,
Angelia

[djk1000 · Accepted solution]

It looks like an issue others are having too,

https://community.powerbi.com/t5/Issues/Gateway-disabled/idi-p/268213/page/2#comments

[v-huizhn-msft]

Hi @djk1000,

You're right. You can follow the cases, the issue has been reported internally to Power BI Team: CRI 49306659. Please wait for the update.

Best Regards,
Angelia

[djk1000 · Accepted solution]

Hi,

I have implemented a workaround for this. I have removed the append query in the query editor and then created a new table in DAX with a UNION of the previously appended queries:

TABLE = UNION(FirstDataSource,SecondDataSource)