Forum Discussion

amitgawali's avatar
amitgawali
Frequent Visitor
8 years ago

Cannot add Data source to Data gateway

Hi ,

 

I have recently upgraded my On-premises data gateway from version 14.16.6524.1 to 14.16.6584.1 and after that I am not able to add data source under Gateways. Hwnever I try to add Data source I get below error:

 

 

 

Can anyone tell, what is resolution of this error?

 

Thanks in advance!

 

Regards,

Amit

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi amitgawali,

     

     

    Can you please provide more detailed information about this issue? It will be help to clarify your scenario.

    Troubleshooting the on-premises data gateway

     

     

     

    BTW, if you remove current datasource and add new datasource with correspond settings, does it works?

     

    Regards,

    Xiaoxin Sheng

    • amitgawali's avatar
      amitgawali
      Frequent Visitor
      8 years ago

      If I remove current Data source and add new then also it is giving me same problem.

      BTW Can you give me answer to this question also?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi amitgawali,

         

        Please share more detailed contents to help us clarify your issue.

        For example:

         

        Collecting logs from the gateway configurator

        There are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the On-premises data gateway user interface, select Diagnostics and then select the Export logslink near the bottom of the page, as shown in the following image.

        On-prem-data-gateway-UI-logs

        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.

        Refresh History

        When using the gateway for scheduled refresh, Refresh History can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the Refresh History.

        1. In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.

        2. In Settings for... > Schedule Refresh, select Refresh History.

         

        Regards,

        Xiaoxin Sheng