Forum Discussion

jordimr's avatar
jordimr
Advocate I
10 years ago
Solved

Problems with personal gateway

I have problems with the personal gateway. Here's the scenario:
-Report is succesfully published to the service.
-The report uses two sources:
-one is a local file present in the machine where the gateway is installed.
-the other one is a SQL server accessible from Corpnet (FMT / BMX data).
-The gateway is reported as up and working.

If l run the report in the machine with the desktop designed, it refreshes data just fine. Both local and SQL source. However, from the expand I have problems with the personal gateway. Here's the scenario:

  • Report is succesfully published to the service.
  • The report uses two sources:
  •        one is a local file present in the machine where the gateway is installed on
  •        the other one is a SQL server accessible from our corporate network.
  • The gateway is reported as up and working.Online. GW is installed on Server A.
 
If l refresh the report in Server A with Desktop BI, it refreshes data just fine. Both form the local and SQL sources. Connectivity between Server A where the gateway is installed, and the database works, and credentials are correct.
 
However, if I try to refresh from the service page it gives me an error on the credentials of the SQL source.

The strangest thing of all, is that this used to work fine, but when I had to change my password last week, and had to update it on the gateway, it's stopped working. I've uninstalled the gateway many times, and even changed the machine I used as gateway, all to no avail.

Any help appreciated!!!!
 
Here are some of errors I am getting:
 
Data Source cannot be updated because credentials are wrong. Hide details:
Id. de actividad:a17664c1-f460-464f-9353-61b8776801aa
Id. de solicitud:24283130-096a-d64f-ec40-94c35e97df13
Código de estado:200
Hora:Tue Oct 06 2015 11:01:10 GMT+0200 (Romance Daylight Time)
Versión:11.0.9168.224
 
When clicking on update credentials (even though gateway is reported online above!):
No se pudieron actualizar las credenciales de origen de datos: GatewayOffline
Ocultar detalles
Id. de actividad:a17664c1-f460-464f-9353-61b8776801aa
Id. de solicitud:30d24337-c50d-3116-cbf1-cfd53d492888
Código de estado:500
Hora:Tue Oct 06 2015 11:22:14 GMT+0200 (Romance Daylight Time)
Versión:11.0.9168.224
URI de clúster:https://df-msit-scus.analysis.windows.net
  
  • kcantor's avatar
    kcantor
    10 years ago

    A similar situation happened to me. I had updated the PowerBI desktop but failed to update my Gateway at the same time. I contacted support and was told to update my Gateway EVERY TIME I update the desktop. My credentials worked as they should and I have not had any further issues. I would recommend doing a quick update of both and trying to refresh again.

    Remember, what worked for me may not work for you but it is worth a shot.

    K

3 Replies

  • jordimr's avatar
    jordimr
    Advocate I
    10 years ago

    The latest version of the personal gateway solved the issue for me. I believe it was linked to the timeout settings. It was resolved anyway.

  • mininair's avatar
    mininair
    Microsoft Employee
    10 years ago

    jordimr: did you try updating your credentials in the dataset settings? In the dataset on the schedule refresh settings page, if you click on "edit credentials" under the sql server datasource, you can update the credentials. Did you give this a shot? Does refresh still fail?  

  • kcantor's avatar
    kcantor
    Community Champion
    10 years ago

    A similar situation happened to me. I had updated the PowerBI desktop but failed to update my Gateway at the same time. I contacted support and was told to update my Gateway EVERY TIME I update the desktop. My credentials worked as they should and I have not had any further issues. I would recommend doing a quick update of both and trying to refresh again.

    Remember, what worked for me may not work for you but it is worth a shot.

    K