I, I successfully uninstalled personal gateway from my server.But it is still visible on app.powerbi.com, with an error saying that gateway is unavailable.I can't refresh my datasources because of this error. Can you help me ?

Did this get solved? I've uninstalled (from control panel, no errors) the Personal Gateway. I want to switch a data source (SQL Server DB) over to the Enterprise gateway now that it's available to me. I can't. PowerBI still thinks my personal gateway is installed. When will it "un-register" or forget it's there & allow me to use the Enterprise Gateway?

This solved it for me:Open the PBIX file. Get into Edit Queries. For each table, get into the Advanced Editor. Check the Server and Database name in the second line ( Source = Sql.database("server","database") ). Once I made sure that the server name and database name referenced here match a server name and database name of a Data Source in the Enterprise Gateway, then I was able to connect the Dataset and configure refreshes. In my opinion, at least for me, the orphaned Personal Gateway was only the fall back default because Power BI could not find a matching pair of server/database for the Dataset. Once that was rectified, the issue was resolved. Hope this helps.

As smoupre suggests, if you install the personal gateway somewhere else, PowerBI notices the change of hosts and is able to refresh the data sources. I did this yesterday and it succeeded.

Anonymous Good thoughts. Here's what I tried & the outcomes:Built brand new PBIX, with same SQL Server & DB, published. Clicked on Sched-Refresh -> YES! I can choose between my (defunct, but still there) Personal GW or the Enterprise Gateway. Works.So, we know that the gateway is alive & working for me.Though - odd - it still thinks my PG is registered, but offline.Opened the original PBIX:Ensured that the queries reference the exact SQL server name & DB name (even making sure I'm not using FDQN in the PBIX, but just the hostname in the gateway settings), re-publish -> Same error, says my PG is offline, EG grayed out.Opened the original PBIX:Saved it as a different file entirely. Publish the duplicate -> Same error, says my PG is offline, EG grayed out.Opened the original PBIX:Completely remove all saved data sources - deleted them all from the PBID data source settings. Save. Refresh the PBIX in the PBID, re-connected to the SQL server, Publish -> Same error, says my PG is offline, EG grayed out.Open a ticket with MS Support -> waiting on call.

Evogelpohl Thanks for the detailed response. Yeah, that pretty much exhausts everything I can think of. Be sure to update this thread when/if they figure out what the problem was... I'll be interested in to hearing what it is.

How to remove personal gateway from app.powerbi.com

Forum Discussion

45 Replies

Related content