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

45 Replies

Anonymous
Not applicable
9 years ago
This is still not fixed:

https://community.powerbi.com/t5/Service/How-to-disassociate-with-a-Personal-Gateway/
JorgenHNO3
Advocate I
9 years ago
There is a lot of talk about uninstalling the client gateway. But my problem is that I can't get rid of the references to some gateway that does not exist.

1) When open the manage gateways there is no gateway. It's been removed
2) When I try to set a refresh (I know I need a gateway and if I install a new one it looks the same) all options are greyed out and it says --->> Use your data gateway (Power BI - Personal) (Offline running on MicrosoftBI) A server that no longer exists

So the basic question -- Is there any way of the removing references to old gateways on the powerbi service.

And why can't I just cut and paste a screen dump here it would have made life a lot easier :)

I can't install a gateway and I can't use my old data sets.....
- jmdh
  Advocate IV
  9 years ago
  This is Exactly the issue i have (and have had for more than a month with support).
  However , i belive someone is now looking into it.
  My guess is that the Gateway "existence" must be stored somewhere on Office 365 / Azure, because in my case it was not even installed on my PC but on an other machine, so how does PowerBI know about it still?
  And the annoying fact is that we have no way to admin it...
- jmdh
  Advocate IV
  9 years ago
  By the way, i overcame the "Can't install" by installing an On Pr"mise gateway, instead of reinstalling a Personal Gateway and it worked for me,
  
  PS as to the screenshots i agree, you have to first create images etc
Greg_Deckler
Community Champion
10 years ago
I'm thinking you should send this one to support. In service, click smiley icon in upper right and attach screen shot of the gateway being unavailable and explain that you have uninstalled the personal gateway.

You could also try installing the personal gateway on another box and once it shows up, in theory you should be able to refresh your data sources.
- JBeyers
  Advocate IV
  10 years ago
  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.
  - Evogelpohl
    Helper V
    10 years ago
    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?
ToddChitt
Super User
10 years ago
Ditto that. I too have a Personal Gateway installed on a VM that NO LONGER RUNS, but for some reason, when I deploy a DataSet to Power BI via a PBIX file, then try to set up Scheduled Refresh on it, it seems to be stuck to the Personal Gateway, even though this particular PBIX was created on a machine and connected to data on a machine that has a functioning Enterprise Gateway installed.
- Evogelpohl
  Helper V
  10 years ago
  ToddChitt Anonymous.
  
  Update: I've been working with a Support rep @ MS for this issue. Still occurs. He ran me through the same bullets items I did in an earlier post. Same outcome - the Service still thinks my PG is registered, but offline & won't let me convert the data set over to the EG.
  
  He told me that "it takes special permission from Microsoft for him to be able to view issues w/ my PG" - he's working to get that approval. Told me to stand by.
  
  -Eric.
  - ToddChitt
    Super User
    10 years ago
    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.
JorgenHNO3
Advocate I
9 years ago
I'm having exactly the same problem. I can't connect new data sources to my On Premises Data Gateway which I have installed
How do I get rid of this Personal Gateway ????

When I try to connect it just says --Use your Data gateway (Power BI Personal)
AND I can¨t see the other gateway (my installed on premise gateway)

This is not just annoying it stops me from refreshing reports...
sieed
Helper II
9 years ago
Was any one able to resolve this issue? I successfully uninstalled personal gateway and reinstalled on premise. But whenver I want to do a schedule refresh, am getting the message saying that the personal gateway is offline. Now obviously it will be since I have already removed t. But then if I have removed it, then it should not even appear.
- jmdh
  Advocate IV
  9 years ago
  This is the symptom i have.
  Support (which took 5 weeks to give an answer due to a "huge backlog") finally admitted that there was a problem after discussion with the dev team.
  I am hoping to see some positive results since on the support page of PowerBI there is a mention od the issue with the Gateway...
  - Anonymous
    Not applicable
    9 years ago
    It is good that they <finally> admit there is an issue.
    
    I'm really unimpressed with the time to not-resolve it though.
- Anonymous
  Not applicable
  9 years ago
  The story here was that you shouldn't have to reinstall any gateway to "fix" the problem.
  
  So, no. This is still very much an unresolved issue.
marke
Regular Visitor
9 years ago
Has anyone had any luck with this one, in my case i have never had a personal gateway installed on my pc, published two .pbix files to the web service that have a data source in AWS and i cannot refresh them as the power bi service says my personal gateway is offline.

I go to manage gateways and there are none there ?

Any ideas would be most appreciated
- jmdh
  Advocate IV
  9 years ago
  Sorry, can't help beacuse i have no experience of data stored in AWS with Power BI.
  What i can say is that if you access your data in Web Mode ie Get data Web AND the file(s) are on OneDrive Pro or as a SharePoint Folder, Refreshes work without the need for a gateway.
vtcusascott
Frequent Visitor
9 years ago
I am having this issue now. Because of this I have to manually refresh. Defeats the purpose. This is a major flaw it needs to be addressed.