Bulk update datasource type

[Krishanu]

Hello Experts,
Help Needed!

We have a requirement where we need to repoint many (500+) existing reports from synapse (Azure sql dw) to Snowflake.

Is there any programatic way to do this update in bulk? The Rest api we have seen - https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources-in-group , but this doesn't support changing datasource type.

Any way to do this without making changes individually?

Thanks,

Krishanu

[Krishanu]

@bcdobbsany luck with this please?

[Krishanu]

Some more info:
Synapse and Snowflake table/schema structures are same.

The query patterns are following:

Synapse:

let
Source = Sql.Database("Synpase Server", "Synapse Database"),
AdventureWorksDW2017 = Source{[Name="AdventureWorks"]}[Data],
dbo_DimProduct = AdventureWorksDW2017{[Schema="dbo",Item="DimProduct"]}[Data]
in
dbo_DimProduct

Also we have seen this -
let
Source = Sql.Databases("Synpase Server"),
#"dw-prod" = Source{[Name="Synapse Database"]}[Data],
dbo_DimCustomer = #"dw-prod"{[Schema="dbo",Item="DimCustomer"]}[Data]
in
dbo_DimCustomer
----------------------------------------------------------------------------------------------
For Snowflake:

let
Source = Snowflake.Databases("Snowflake Server", "Snowflake Warehouse", null),
Test_Database = Source{[Name="Test",Kind="Database"]}[Data],
IM_Schema = Test_Database{[Name="IM",Kind="Schema"]}[Data],
Test1_Table = IM_Schema{[Name="Test1",Kind="Table"]}[Data],
in
Test1_Table

[bcdobbs]

Few questions:

Does each report have it's own dataset?

Do you premium capacity or ppu?

Not sure how easy it is (never tried) but if you have premium you can connect to a workspace via an xlma end point and interact the tabular object model (TOM) with a c# script. You'd have to loop through each workspace/dataset in turn though. 

Have a read of

https://docs.microsoft.com/en-us/analysis-services/tom/tom-pbi-datasets?view=asallproducts-allversio...

[Krishanu]

Thanks for replying.
Yes, we have premium and 90-95% of the reports have their own data set, remaining will be over shared dataset.

Anyone has any sample script on this line please?