Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Is it possible to script the installation of an On-premises data gateway, and add Data Sources to that Gateway programmatically?
Thank you!
Andrew
Solved! Go to Solution.
Hi @gemmillab
Based on my reaserch, some users can install the gateway with Powershell, but it doesn't support to register or configure for the gateway.
Also there is no any official documentation or article which provides the scripts to install and configure it, i'm not very clear about whether it can be achieved. Thus i email to PG to confirm whether it works or not just now, and i will come back to tell you as soon as i get reply.
However, it is possible to add data source to gateway programmatically using REST API, for more details, please review the
REST API documents and this similar thread, besides, you could use PowerShell gateway commands.
Best Regards
Maggie
Hi @gemmillab
Based on my reaserch, some users can install the gateway with Powershell, but it doesn't support to register or configure for the gateway.
Also there is no any official documentation or article which provides the scripts to install and configure it, i'm not very clear about whether it can be achieved. Thus i email to PG to confirm whether it works or not just now, and i will come back to tell you as soon as i get reply.
However, it is possible to add data source to gateway programmatically using REST API, for more details, please review the
REST API documents and this similar thread, besides, you could use PowerShell gateway commands.
Best Regards
Maggie
Hi @v-juanli-msft .
Did you ever get a response to your email regarding the ability to automate/script the installation (and/or configuration) of the PowerBI Gateway?
Do you know if it is possible to achieve?
Many thanks.
Best Regards,
Craig.
@v-juanli-msft wrote:Hi @gemmillab
Based on my reaserch, some users can install the gateway with Powershell, but it doesn't support to register or configure for the gateway.
Also there is no any official documentation or article which provides the scripts to install and configure it, i'm not very clear about whether it can be achieved. Thus i email to PG to confirm whether it works or not just now, and i will come back to tell you as soon as i get reply.
However, it is possible to add data source to gateway programmatically using REST API, for more details, please review the
REST API documents and this similar thread, besides, you could use PowerShell gateway commands.
Best Regards
Maggie
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!