Forum Discussion

Ashikdevops's avatar
Ashikdevops
New Member
1 year ago
Solved

PowerBi rest API for update data source of different kinds

Here the problem is:

Present datasource in report is of the data source type SQL; Having connection details as server,database

 

The task is I need to update data source connection with the data source type of SNOWFLAKES

The details I have wrt snowflakes: server, username, password,warehouse,database,schema, table

 

I need tu change data source connection from SQL to snowflakes in automated way 

 

 

I tried invoke powerbi rest method of update data source connection , but it doesn't allows me to change the data source type and functioning as I required mentioned above.

 

Please give the solution.

Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. I'm sorry but that is not possible. The Rest API will let you update data sources is limited for specifc sources like: SQL Server, Azure SQL Server, Azure Analysis Services, Azure Synapse, OData, SharePoint, Teradata, and SAP HANA. You can't do it from one source to another. It's for changing conection details only. Snowflake is not a source that you can handle in there. As an alternative when you need to change conection details of another source you can use power query parameters, but again, that's for changing details of the same source, it's not for changing from sql to snowflake.

    Sadly, there is no automated way for this. You should open the semantic models one by one and change them at query editor with power bi desktop.

    I hope that make sense,

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    1 year ago

    Hi. I'm sorry but that is not possible. The Rest API will let you update data sources is limited for specifc sources like: SQL Server, Azure SQL Server, Azure Analysis Services, Azure Synapse, OData, SharePoint, Teradata, and SAP HANA. You can't do it from one source to another. It's for changing conection details only. Snowflake is not a source that you can handle in there. As an alternative when you need to change conection details of another source you can use power query parameters, but again, that's for changing details of the same source, it's not for changing from sql to snowflake.

    Sadly, there is no automated way for this. You should open the semantic models one by one and change them at query editor with power bi desktop.

    I hope that make sense,