Access SQL Server with on-premises data gateway (recommended)

[Howard_Hong]

Hello,

I have a .pbix file on Power BI Desktop, located on Workstation A. It accesses SQL Server data on Server B. I installed "on-premises data gateway (recommended)" on Server B to access data. Is this correct for publishing? I am suppose to install "on-premises data gateway (recommended) on Workstation A instead? And data access reaches through the .pbix file to schedule refresh my dataset? Has this changed recently from something else? I seem to recall having to install the "on-premises data gateway (recommeded)" on Server B instead.

Thanks,

Howard Hong

[v-yuezhe-msft · Accepted solution]

@Howard_Hong,

You can install on-premises gateway on both machines, just make sure that you are able to access SQL Server from the machine that installing the gateway.

After you add the SQL Server data source within gateway, you are able to set schedule refresh for your dataset.

Regards,
Lydia