Forum Discussion

vranjan22's avatar
vranjan22
Regular Visitor
8 years ago

On Premise Data Gateway - Single database, different username

Hi,   I have a on premise data gateway installed on a server which is being used for PowerApps application. I am now creating a PowerBI report from that database(SQL Server Express Edition), howeve...
vranjan22's avatar
vranjan22
Regular Visitor
8 years ago

Hi Anonymous

 

 

I followed the steps mentioned in the link shared by you along with I assigned the Admin access to the id using which I am creating PowerBI report:

 

 

 

 

While adding the data source to the gateway, I am getting the error:

 

 

The user I have created on SQL server and I am using that credential to connect, but unable to do so.

 

Please advise.

 

Thanks,

Vivek

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

vranjan22,

Do you use the same user account and credential to connect to SQL in Power BI Desktop and gateway? If so, are you able to connect to SQL Server from SQL Server Management Studio(SSMS) with this user? Please makke sure SSMS is installed in the same machine with gateway.

Regards,
Lydia