Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello everyone,
I use Power BI Embedded to provide services to customers. Currently, we use a SQL Server on our VPS.
Each customer has a database, and each customer has an associated PBIX file that was associated to the correct DB throw the on-premises data gateway software.
Currently, the process to associate a PBIX file to the database is as follows:
After completing this procedure, the pbix dataset was refreshed correctly .
We are considering switching to an Azure Sql Server Managed Instance.
So, I am testing the integration without using the On-Premises data gateway software.
Through the web interface (Power BI services), it is possible to create a cloud connection (see the screenshot "CloudConnection.PNG").
How can I create the same type of connection via API?
I have checked the outgoing web requests when creating the CloudConnection, and the interface calls this API: https://api.powerbi.com/v2.0/myorg/me/gatewayClusterCloudDatasource, but I cannot find it among the available APIs on https://learn.microsoft.com/en-us/rest/api/power-bi/ .
Thank you all for your support.
Hi @mforte,
If you do not clear how to create similar connection based on REST API, you can build a template version on power bi side at first.
Then you can use REST API to get this connection string and use this template as refence to modify to the fact versions.
Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Xiaoxin Sheng
Hi @Anonymous
Thanks for your reply.
I'm looking for something that need no changes on pbix files.
I just want to connect the report on powerbi service, dinamically whit new Azure SQL server whitout using the On-Premis Data gateway
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
5 | |
2 | |
2 |
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |