Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How do I fix Credentials used by Personal Data Gateway?

Hi there,

We've been using On-premises data gateway (personal mode) for more than a year to extract data from the Web database. Everything worked fine until recently (several days ago) when we started getting creds validation error in Power BI Service:

 

Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://xxx.yyy.com/rest/erp/1.0/bi/project.)

Activity ID:8c026087-cf42-4dc3-a74f-e17754f26e81
Request ID:3facad18-366f-0c5c-ded8-fd06d14ef6ba
Status code:400
Time:Wed Jun 20 2018 16:58:42 GMT+0300 (Moscow Standard Time)
Version:13.0.5702.156
Cluster URI:https://wabi-west-europe-redirect.analysis.windows.net

 

On-premises data gateway (personal mode) ver. 14.16.6724.2 (June 2018)

Power BI Desktop ver. 2.59.5135.601 64-bit (June 2018)

Cache has been cleared in 'Data Cache Management Options'

Privacy Level = Organizational (also tried Public with no difference)

Web Datasource provides requested data in any browser under defined in Power BI creds 

 

Possible reason of the error is that Gateway which is running on my PC (64-bit) keeps trying to authenticate to the Web datasource under my Power BI creadentials (anna.kolbasova), and ignores correct creds defined in Data Source Credentials in Power BI Service. Here's our web datasource response:

 

2018-06-20 14:48:50,102 http-nio-127.0.0.1-8080-exec-37 ERROR anna.kolbasova 888x830412x1 1hwep3l 192.168.98.52,127.0.0.1 /rest/xxx/1.0/bi/resourcing/working [c.s.e.r.provider.exceptionhandler.AccessViolationExceptionHandler]
com.xxx.yyy.exception.AccessException: Access Violation

 

At the same time correct creds are being accepted if I launch the datasource update from the Power BI Desktop... 

 

BR,

Anna  

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    I'd like to suggest you check related api settings if nothing modified on your side. (normally 400 error means httprequests related issues)

     

    You can also use fiddler to trace operation session or share local gateway log to help us clarify your scenario.

     

    Spoiler

    Installer logs

    %localappdata%\Temp\On-premises_data_gateway_*.log

    Configuration logs

    %localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log

    On-premises data gateway service logs

    C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log

    Event Logs

    The On-premises data gateway service event logs are present under Application and Services Logs.

    On-prem-data-gateway-event-logs

    Fiddler Trace

    Fiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hey there,

      We've been using On-premises data gateway (personal mode) for more than a year to extract data from the Web data source. Everything worked fine until recently (several days ago) when we started getting creds validation error in Power BI Service:

       

      Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://xxx.yyy.com/rest/erp/1.0/bi/project.)

      Activity ID:8c026087-cf42-4dc3-a74f-e17754f26e81
      Request ID:3facad18-366f-0c5c-ded8-fd06d14ef6ba
      Status code:400
      Time:Wed Jun 20 2018 16:58:42 GMT+0300 (Moscow Standard Time)
      Version:13.0.5702.156
      Cluster URI:https://wabi-west-europe-redirect.analysis.windows.net

       

      On-premises data gateway (personal mode) ver. 14.16.6724.2 (June 2018)

      Power BI Desktop ver. 2.59.5135.601 64-bit (June 2018)

      Cache has been cleared in 'Data Cache Management Options'

      Privacy Level = Organizational (also tried Public with no difference)

      Web Datasource provides requested data in any browser under defined in Power BI creds 

       

      Possible reason of the error is that Gateway which is running on my PC (64-bit) keeps trying to authenticate to the Web datasource under my Power BI credentials (anna.kolbasova), and ignores correct creds defined in Data Source Credentials in Power BI Service. Here's our web datasource response:

       

      2018-06-20 14:48:50,102 http-nio-127.0.0.1-8080-exec-37 ERROR anna.kolbasova 888x830412x1 1hwep3l 192.168.98.52,127.0.0.1 /rest/xxx/1.0/bi/resourcing/working [c.s.e.r.provider.exceptionhandler.AccessViolationExceptionHandler]
      com.xxx.yyy.exception.AccessException: Access Violation

       

      At the same time correct creds are being accepted if I launch the datasource update from the Power BI Desktop... 

       

      BR,

      Anna