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...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

vranjan22 The gateway is the same for Apps and Power BI. An admin of the gateway can see the gateway you stood up in both applications. In Apps, you created a connection, in Power BI you will most likely need to create a datasource for the same SQL DB. This can be done in Power BI. The admin, would then assign you as a user of the data source so that when you publish the report, you would see that a gateway is available on the dataset for you to schedule a refresh of the report.

This article walks through the data source creation, just ignore the download of the gateway portion because you already have one.

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

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