Forum Discussion
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...
YashikaAgrawal let me ask you this. How are you connecting in Power BI Desktop?
Hi,
Thank you for the reply.
I tried connecting from Power BI service. I got the below error .
Unable to create connection for the following reason: The on-premises data gateway's service account failed to impersonate the user.
I tried giving user name as domain\user.
Domain is where the Power BI gateway server is installed, is this correct?
SQL server is in different location.
Any suggestions please.