Forum Discussion

mforte's avatar
mforte
New Member
2 years ago

Power-BI REST API use Azure SQL Server as datasource

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Datasets - Get Gateway Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Regards,

Xiaoxin Sheng

  • mforte's avatar
    mforte
    New Member
    2 years ago

    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