Reply
avatar user
Anonymous
Not applicable

Mass updating dataset sources

Hi,

 

I have about 100 dataset which are connected to Snowflake. I need to update all 100 to use a new warehouse in Snowflake. The table structure will be the same in the new warehouse and will have the same database name as the old one. Basically I just need to change "xxxx.snowflakexxx.com; warehouse1" to "xxxx.snowflakexxx.com; warehouse2" on all 100 dataset. What would be the easiest way to do this? I tried using UpdateDatasources API but I couldn't get it to work with Snowflake.

3 REPLIES 3
lbendlin
Super User
Super User

I tried using UpdateDatasources API but I couldn't get it to work with Snowflake.

Please elaborate. That API call is usually agnostic to the data source it is modifying

 

avatar user
Anonymous
Not applicable

I tried to use the Update Datasources API. however, it says on the limitations that only the following data sources are supported: SQL Server, Azure SQL Server, Azure Analysis Services, Azure Synapse, OData, SharePoint, Teradata, and SAP HANA. When I tried using it in snowflake, I get a "Parameter updatedetails is missing or invalid" error. The script works when I tried updating one of my sources in SAP.

 

This is the update details parameter I'm using:

 

 

 {
   "updateDetails": [
        {
            "datasourceSelector": {
                "datasourceType":"Extension",
                "connectionDetails": {
                   "path":"snowflake URL;OLD_WH","kind":"Snowflake"
                }
            },
            "connectionDetails": {
               "path":"snowflake URL;New_WH","kind":"Snowflake"
            }
        }
    ]
}

 

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)