Forum Discussion
Krishanu
4 years agoHelper I
Bulk update datasource type
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 ...
bcdobbs
4 years agoCommunity Champion
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
Krishanu
4 years agoHelper I
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?