Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Post Patron
8 months ago
Solved

Connecting Power BI to SQL server

Hello Team,   Working on connecting Power BI to SQL server, getting the error, this is a new Power BI gateway server. The credentails are working in the old server, Any suggestions how to resolve...
Need Help
  • parry2k's avatar
    parry2k
    8 months ago

    YashikaAgrawal let me ask you this. How are you connecting in Power BI Desktop?

parry2k's avatar
parry2k
Super User
8 months ago

YashikaAgrawal  In Power BI service, did you add this as a data source under manage connections and gateways?

  • YashikaAgrawal's avatar
    YashikaAgrawal
    Post Patron
    8 months ago

    Thank you for the reply.

     

    I am try new connection (On-premises), getting failed here itself.
    Connection Name - xxxxx
    Connection - SQL server
    Server name - xxxxx
    Database name - xxxxx
    Authentication type - Windows
    Username (DOMAIN\USERNAME)
    Password xxxxx

     

    Getting error "Unable to create connection for the following reason: The on-premises data gateway's service account failed to impersonate the user."

     

    Thanks,