Forum Discussion
How to remove personal gateway from app.powerbi.com
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.
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.
- Anonymous10 years agoNot applicable
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.
- RonEllisGaut9 years ago
Advocate I
Did you get this issue resolved? I've had the same issue for months and would love to know what the solution is.
- jmdh9 years ago
Advocate IV
Support have given this list of steps (assuming every one uses Powershell) to go through after Uninstall to make sure that the Gateway is removed:
Go to Powershell and run:
get-wmiobject win32_product | select name,identifyingnumber | where {$_.name -like "*data management*"}
This will return the GUID for the package. Then type the following:
msiexec /x '{GUIDforpackage}’
Also (if they exist) remove:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DIAHostService
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataTransfer
HKEY_CURRENT_USER\SOFTWARE\Microsoft\DataTransfer
and remove the following folders
C:\Program Files\Power BI Personal Gateway
C:\Users\<user>\AppData\Roaming\Microsoft\Data Transfer
C:\Users\<user>\AppData\Local\Power BI Personal Gateway
C:\Users\<user>\AppData\Local\PowerBI Personal Gateway
in my view the last two lines above should be :
C:\Users\<user>\AppData\Local\Microsoft\Power BI Personal Gateway
C:\Users\<user>\AppData\Local\Microsoft\PowerBI Personal Gateway
However, this has not worked for me.
There is also this article, about the PBIEgwService service
Net net, 4 and a half weeks after cbeing in contact with support , i had a message yesterday from someone who undertsood the issue, so i am hopeful.
jmdh
- cweberITS10 years agoNew Member
I am also having this problem. I second Anonymous in asking for you to keep us updated.
Thanks!Cris
@cweberits
Cloud Services Architect at @ITS_Partners
Just making ConfigMgr as a Service at https://itsdelivers.com/future
- szilardsz9 years ago
Advocate I
+1, the same problem here.... thx!
- dcresp9 years ago
Advocate IV
I am getting exactley the same issue.
- Anonymous9 years agoNot applicable
I also have same problem with personal gateway I can't remove from app.powerbi.service. And best part is, I am only testing http://www.timeapi.org/pst so there is no special data source?
Hope this posts bring some attention from MS team to our problem.
- dcresp9 years ago
Advocate IV
I am still gettting the same issue. Are there any updates on this issue? howtomicrosoft
- jmdh9 years ago
Advocate IV
I am experiencing the same issue (Gateway uninstalled but message saying that is is offline) and have contacted support two weeks ago and still waiting (but hoping) to get a resolution...
Have installed successfully gateway on Machine 2 and it works but when i uninstall i have agian the same problem.
- Anonymous9 years agoNot applicable
Sorry to hear that you are having this problem too.
Definately seems that addressing this is a low priority for MS which is very annoying.
- Anonymous9 years agoNot applicable
Thanks for that.
This is now beyond a minor annoyance for me too!!!
Just to reiterate to any MS people watchin this thread - the PC that had Personal Gateway installed DOES NOT EXIST ANY MORE SO I CAN'T UNINSTALL ANYTHING.
I'm now getting emails telling me that my PowerBI Service data refreshes failed because my Personal Gateway is off line....
This is very very wrong, becuase the Enterprise Gateway is Offline.....
Grrrrrrrr.
- GilbertQ9 years ago
Super User
Hi Anonymous
For your issue could you not possibly go into the Dataset and change it from the current gateway to connect directly?
As well as potentially remove the schedule, so that you do not receive the emails due to there being no refreshing happening?
- jmdh9 years ago
Advocate IV
Hi,
In the Service, the option to select between Gateway and Connect Directly is greyed unfortunately: i cannot change ; if you know how to allow that change, this would solve my issue.