Forum Discussion
Solved
Access SQL Server with on-premises data gateway (recommended)
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....
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
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