Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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