Forum Discussion

kakkaroolari's avatar
kakkaroolari
Frequent Visitor
6 years ago

Personal Gateway fails to synchronize SQL server with Windows authentication

BACKGROUND   I have a company e-mail / windows user account linked to Power BI license, let's call it 'user' - '[email protected]'   I have an on-premises Windows server into which I log using 'se...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi kakkaroolari ,

 

There are some points you may considerate:

 

1.Make sure the account signing in the personal gateway is the same with the Power BI Service.

 

2.Make sure the connect credential of SQL Server in Power BI Service is the same in Power BI Desktop. Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method. When connect to the SQL Server, set the Authentication as Windows instead of Basic.

 

3.Make sure the gateway was installed on the same machine as the SSMS exists.

 

4.Please make sure the gateway is online, and try to upgrade the gateway to latest version.

 

5.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset, select Edit credentials to update the credentials for the data source.

 

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • kakkaroolari's avatar
    kakkaroolari
    Frequent Visitor
    6 years ago

    This answer is almost fully unrelated.

     

    Item 3. Why would Microsoft SQL Server Management Studio would need to be installed in a Windows Server where the personal gateway is running?

     

    WHEN

    I login to "Personal gateway" with 'user' - '[email protected]' 

     

    THEN

    1 out of 4 datasources in the "personal gateway" fails with error  'server_user' - '[email protected]' does not have privileges.

     

    RESULT:

    This is true,  'server_user' does not have privileges to the Cube

     

    EXPECTED RESULT:

    Cube would try to sync with the user that has Signed in to "Personal gateway" and "power bi service"

    • kakkaroolari's avatar
      kakkaroolari
      Frequent Visitor
      6 years ago

      Is there any way I can force Personal Gateway to connect to datasources with username, and not e-mail address?

       

      Our company policy is to have two usernames with desktops and different one for servers. And the Gateway seems to select wrong one randomly.

       

      Some hidden config somewhere?

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi kakkaroolari ,

         

        >>Item 3. Why would Microsoft SQL Server Management Studio would need to be installed in a Windows Server where the personal gateway is running?

         

        If you need to connect to SQL Server in SSMS, you may need to do so.

         

         

        >>Is there any way I can force Personal Gateway to connect to datasources with username, and not e-mail address?

         

        You can sign in personal gateway with the account which you would like to use in Power BI Service.

         

        For reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode.

         

        Best Regards,

        Amy

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.