Forum Discussion
How to remove personal gateway from app.powerbi.com
Helper VAnonymous 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.
Advocate IDid you get this issue resolved? I've had the same issue for months and would love to know what the solution is.
jmdhAdvocate 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
szilardsz+1, the same problem here.... thx!
- dcresp
I am getting exactley the same issue.
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.
- dcresp
I am still gettting the same issue. Are there any updates on this issue? howtomicrosoft
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.
- GilbertQ
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?
- jmdh
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.
