Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Gateway data source setting Error

Hi , I'm encountering an issue with date source setting. When I added one data source in dataset, it shows below error.

I'm sure that the username and password is correct, domain/username with password. 

What's the meaning of "the parameter is incorrect" ? I don't have any parameter in the dataset. 

 

Thanks!

  • Anonymous's avatar
    Anonymous
    6 years ago

    v-easonf-msft , 

     

    Sorry for the late response. This issue has been resolved and thanks for the support from Microsoft team. 

     

    Here is the step which fixed the issue. 

     

    1. change the service account from default PBI service account to local system account.
    2. restart the service in on-premised gateway.
    3. restart the on-premised gateway and re-register your account. Migrate the existing gateway cluster to the new registered gateway.
    4. add the data source to the gateway connection again on cloud.

     

    But I'm not sure about the root cause. At least this issue has been resolved :). 

     

    Thanks!

12 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi ,  Anonymous 

    If you have make sure that all data source credentials are correct, please recheck the statue of your  data gateway.

    Take a try to install the latest version of On-premises Data Gateway 

     

    You may refer to this document to collect  more information from gateway logs and event logs.

     (look in Event Logs > Applications and Services Logs > On-premises data gateway Service )

     

    Best Regards,
    Community Support Team _ Eason

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-easonf-msft , 

       

      I already have the latest version. And there is no special in the event log. But the issue is still there. 

       

      The tricky thing is I have several previous data source using same credential is working well. But when I want to create the new one , it has the issue. all the file is from the same place , so it should not be the permission issue.

       

      Thanks!

      Jack

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi, Anonymous 

        What type of data source?Are the gateway and data source in the same domain?

         

        If your data source is tabular data, you may consider whether it is caused by some parameters of the table (such as table name,  table structure, etc.)

         

        It is recommended to create a support ticket to investigate this issue.Once you create a support ticket and get any workaround, please kindly share it here for reference.
        https://powerbi.microsoft.com/en-us/support/

         

        Best Regards,
        Community Support Team _ Eason

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi ,  Anonymous 

    Could you please tell me whether your problem has been solved?
    If it is,  please add your reply  and mark it as Answered to close this thread.
    More people will learn new things here.

    Best Regards,
    Community Support Team _ Eason

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-easonf-msft , 

       

      Sorry for the late response. This issue has been resolved and thanks for the support from Microsoft team. 

       

      Here is the step which fixed the issue. 

       

      1. change the service account from default PBI service account to local system account.
      2. restart the service in on-premised gateway.
      3. restart the on-premised gateway and re-register your account. Migrate the existing gateway cluster to the new registered gateway.
      4. add the data source to the gateway connection again on cloud.

       

      But I'm not sure about the root cause. At least this issue has been resolved :). 

       

      Thanks!