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 passw...
  • 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!

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-easonf-msft ,

     

    The data source is excel table. And the data source and gateway are in same domain. 

    I have check the previous configured data source. All are working well. But I might need to understand how I can input the windows username and password. I tried to replace the same username (I input in new data source) in the previous data source. it has the same error. 

     

    So I need to know what I input in the past for the previous data source. But it's hided. How do I know the previous input username and password ?  I tried everything I can try in the past few days. <domain name>/username , [email protected], <domain name>. <suffix>/username , <domain name>/<full name>. All failed.

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

      Hi , Anonymous 

      Sorry for security reasons it is difficult to see the hidden password .The credentials are encrypted securely. They use symmetric encryption so that they can't be decrypted in the cloud before they're stored in the cloud. The credentials are sent to the machine that runs the gateway, on-premises, where they're decrypted when the data sources are accessed.

       

      If you didn't  not know what your windows username is, and you might not be a domain administrator. You can use the following command from your workstation to find out it for your account ( windows username format: <domain> \ <username > ).

      Please note that "\", not "/"

      whoami

       

       

      Best Regards,
      Community Support Team _ Eason

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        v-easonf-msft , I already tried this. But unfortunately, it doesn't work.