en en ms fi fi fi ms fi fi fi fi fi ms hbs_lat ms sl ms fi fi fi ms ms fi fi it fi en fi fi en fi fi fi fi fi fi fi fi fi fi fi fi fi fi sq fi en fi fi fi fi fi eu fi fi fi de id fi fi fi fi fi fi fi fi fi fi fi fi fi tr fi fi fi ms en en en en fi en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en fi fi fi fi fi fi fi fi fi fi fi fi fi fi ca en en id en en en en en en en en ms ms ms en en ml fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi en fi ms en en en fi vo fi fi fi fi fi ms sl fi fi en fi fi fi fi de fi fi id fi en fi fi sv fi fi fi hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko nb nl nl pl pt pt ru sv th tr zh zh ar he
Failure installing the Power BI Personal Gateway | Microsoft Power BI – blogi | Microsoft Power BI
Office 365 + Power BI
When trying to install the Power BI Personal Gateway, you may encounter the following error.
Please uninstall the Power BI Analysis Services Connector before continuing.
We had a customer contact us indicating that they didn’t have the Analysis Services Connector installed.  So, there was nothing to uninstall.
You should absolutely check to see if you can Uninstall the Analysis Services Connector.  If this message comes up, that means the Analysis Services Connector was on the machine at one point in time.  It may have been uninstalled and left behind some items.
Down below, I list out what you can do for a manual uninstall, or clean up.  But, before getting into that, I wanted to show you how I discovered the registry key that is causing the above dialog.
We can get more information from the Log file that has a link on this dialog.  In the log, we can see the following, interesting, information.
Action start 14:15:08: FindRelatedProducts.MSI (s) (A4:D4) [14:15:08:082]: PROPERTY CHANGE: Adding CONNECTORFOUND property. Its value is '{10DC0C9E-E3CF-4B98-9C77-57A509273DD4}'.MSI (s) (A4:D4) [14:15:08:082]: PROPERTY CHANGE: Adding DMGFOUND property. Its value is '{5616EF4F-D8C5-4100-BA69-ACE644F9AF65}'.MSI (s) (A4:D4) [14:15:08:082]: Skipping action: PreventDowngrading (condition is false)MSI (s) (A4:D4) [14:15:08:082]: Doing action: UninstallConnectorMSI (s) (A4:D4) [14:15:08:082]: Note: 1: 2205 2:  3: ActionText Action ended 14:15:08: FindRelatedProducts. Return value 1.Action start 14:15:08: UninstallConnector.MSI (s) (A4:D4) [14:15:08:082]: Note: 1: 2205 2:  3: Error MSI (s) (A4:D4) [14:15:08:082]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 MSI (s) (A4:D4) [14:15:08:082]: Product: PowerBiGatewayComponents — Please uninstall the Power BI Analysis Services Connector before continuing.
Here we can see the CONNECTORFOUND item that referenced a GUID.  This is actually coming from what is called Upgrade Codes for Windows Installer.  We check to see if we can find the Upgrade Code.
I started by using Process Monitor (ProcMon) from SysInternals. I tried searching for the following GUID, both with and without the hyphens.
Unfortunately, that wasn’t found directly.  You can actually see the UpgradeCode lookups in the registry from the Power BI Gateway Installer process.  From there you can kinda figure it out with a little poking around.
Being ProcMon didn’t find anything, I knew this was coming from the registry, so I went right to the Registry Editor (regedit) to look for it directly.
NOTE: Please use extreme causing when using the Registery Editor (Regedit) as you can cause serious issues with your machine.
We can find this guid as the Source of the following product.
And looking at that product, we see it has the name of PowerBiConnectorComponents.  Which we saw referenced in the MSI Log, so we are on the right track.
From there, we can search for the Product GUID.  This will actually show the UpgradeCode item within ProcMon.
We will find it referenced in the following UpgradeCode.
This is the key that is actually blocking the Personal Gateway installation.
Being we can’t uninstall it, as it isn’t present, that leads us to have to cleanup whatever remnants are remaining on the machine. A manual uninstall, if you will.
Cleaning out the AS Connector
1. Uninstall the Analysis Services Connector
The first thing we should always do is verify if we can actually uninstall it, or not, from Control Panel.  This is the best way to do things as it should remove what it placed down.
2. Delete Upgrade Code from Registry
Delete the Upgrade Code from your System Registry.  On my system, it was located in the following key.  It may be different on yours, so be sure to do what I did above to verify it.
3. Delete the DataTransfer key from the Registry
This key contains all of the configuration information for the Connector.  We want to make sure this is gone.  When we install the Personal Gateway, it will recreate it with the appropriate settings.
4. Delete the Data Management Gateway Folder
You may, or may not, have this folder on your system.  You should remove it through as part of the clean up.
C:\Program Files\Microsoft Data Management Gateway
5. Delete the Analysis Services Connector Folder
This folder should also be deleted when performing a clean up.
C:\Program Files\Power BI Analysis Services Connector
Install the Personal Gateway
After that is done.  You should be able to install the Personal Gateway without issue.
Adam W. Saxton | Microsoft Business Intelligence@GuyInACube | YouTube | Facebook.com\guyinacube
Tilaa Power BI -uutiskirje
Rekisteröidy alla, niin saat uusimmat Power BI -tiedot suoraan Saapuneet-kansioon.
Maa Afganistan Ahvenanmaa Alankomaat Albania Algeria Amerikan Samoa Andorra Angola Anguilla Antarktis Antigua ja Barbuda Argentiina Armenia Aruba Australia Azerbaidžan Bahamasaaret Bahrain Bangladesh Barbados Belgia Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia ja Hertsegovina Botswana Bouvet'nsaari Brasilia Brittiläinen Intian valtameren alue Brittiläiset Neitsytsaaret Brunei Bulgaria Burkina Faso Burundi Cabo Verde Caymansaaret Chile Cookinsaaret Costa Rica Côte d'Ivoire Curaçao Djibouti Dominica Dominikaaninen tasavalta Ecuador Egypti El Salvador Eritrea Espanja Etelä-Afrikka Etelä-Georgia ja Eteläiset Sandwichsaaret Etelä-Sudan Etiopia Falklandinsaaret Fidži Filippiinit Färsaaret Gabon Gambia Georgia Ghana Gibraltar Grenada Grönlanti Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard ja McDonaldinsaaret Honduras Hongkong, erityishallintoalue Huippuvuoret Indonesia Intia Iran Irlanti Islanti Israel Italia Itävalta Jamaika Jan Mayen Japani Jemen Jerseyn voutikunta Jordania Joulusaari Kambodža Kamerun Kanada Kazakstan Kenia Keski-Afrikan tasavalta Kiina Kirgisia Kiribati Kolumbia Komorit Kongo Kongon demokraattinen tasavalta Kookossaaret Korean tasavalta Kosovo Kreikka Kroatia Kuwait Kypros Laos Latvia Lesotho Libanon Liberia Liechtenstein Liettua Luxemburg Macao, erityishallintoalue Madagaskar Malawi Malediivit Malesia Mali Malta Mansaari Marokko Marshallinsaaret Martinique Mauritania Mauritius Mayotte Meksiko Mikronesia Moldova Monaco Mongolia Montenegro Montserrat Mosambik Namibia Nauru Nepal Nicaragua Niger Nigeria Niue Norfolkinsaari Norja Oman Pakistan Palau Palestiinalaishallinto Panama Papua-Uusi-Guinea Paraguay Peru Pitcairn Pohjois-Makedonia Pohjois-Mariaanit Portugali Puerto Rico Puola Päiväntasaajan Guinea Qatar Ranska Ranskan eteläiset alueet Ranskan Guayana Ranskan Polynesia Réunion Romania Ruanda Ruotsi Saba Saint Barthélemy Saint Kitts ja Nevis Saint Lucia Saint Martin Saint Vincent ja Grenadiinit Saint-Pierre ja Miquelon Saksa Salomonsaaret Sambia Samoa San Marino São Tomé ja Príncipe Saudi-Arabia Senegal Serbia Seychellit Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakia Slovenia Somalia Sri Lanka St. Helena, Ascension, Tristan da Cunha Sudan Suomi Suriname Swazimaa Sveitsi Syyria Tadžikistan Taiwan Tansania Tanska Thaimaa Timor-Leste Togo Tokelau Tonga Trinidad ja Tobago Tšad Tšekin tasavalta Tunisia Turkki Turkmenistan Turks- ja Caicossaaret Tuvalu Uganda Ukraina Unkari Uruguay Uusi-Kaledonia Uusi-Seelanti Uzbekistan Wallis ja Futuna Vanuatu Vatikaanivaltio Venezuela Vietnam Viro Yhdistyneet arabiemiirikunnat Yhdistynyt kuningaskunta Yhdysvallat Yhdysvaltain Neitsytsaaret Yhdysvaltain pienet erillissaaret Zimbabwe
Haluan saada seuraavan Power BI -uutiskirjeen. Tietosuojatiedot.
Osallistuminen edellyttää henkilökohtaisten tietojesi siirtämistä muihin maihin, joissa Microsoft toimii, muun muassa Yhdysvaltoihin. Lähettämällä tämän lomakkeen suostut tietojesi siirtämiseen Kiinan ulkopuolelle. Tietosuojalauseke.
Mikä on Power BI?
Power BI on yritysanalytiikan työkalupaketti tietojen analysointiin ja merkityksellisten tietojen jakamiseen. Seuraa liiketoimintaa ja hanki nopeasti vastauksia monipuolisista raporttinäkymistä, joita voi käyttää kaikissa laitteissa.
Hanki viimeisimmät uutiset Power BI -blogista
Tilaa sähköpostitse Sinun on annettava kelvollinen sähköpostiosoite Olet antanut henkilökohtaisen sähköpostiosoitteen. Anna työpaikan tai oppilaitoksen sähköpostiosoite. Tapahtui virhe. Yritä myöhemmin uudelleen.
Näytä kaikki ladattavat tiedostot