Forum Discussion
How to remove personal gateway from app.powerbi.com
Helper VDid 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?
Evogelpohl I believe if you have access to the EG, the option to move should be there regardless of your personal gateway being online or not... Have you confirmed that the datasource you are using has been created in the EG, and that your user has been applied to that data source in the EG? Both those are prerequisites to being able to publish workbooks using the EG.
- Evogelpohl
Thanks Anonymous for the follow up.
Yes, under "manage gateways", I have confirmed that the SQL server hosting the DB that my PBIX queries is listed, with my credentials. The PBIX refreshes fine on the desktop using my credentials. The manage-gateway test-service says: "Online, You are good to go"
I still can't switch my PBIX data source over to the EG.
Yet & still - my personal gateway is still being referenced in the service. Even if I could register this data source w/ the EG, it still seems like a bug that PowerBI is not aware that I've totally removed my Personal Gateway.
Eric.
Evogelpohl Do me a quick favor. What happens when you create a new PBIX to the SQL data source in the same way as the other file (import/direct query) and just add a quick visual, publish to the Service. Does the new report/datasource use the EG? I want to see if the behavior is the same or if it works.
- Evogelpohl
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.