Schema update post addition/deletion in data source

[kunalgupta]

I am trying to setup Power BI with Snowflake as back data source.

I have a usecase to add/remove columns in data source dynamically (less frequent but possible).

I want my semantic data model to be udpated with column updates, is there a way to automate this? ( I do not want to do it manually) 

If there is any sample script or any other setup avaialble would appreciate if can be shared!

Thanks for helping!

[v-xiaocliu-msft]

Hi @kunalgupta ,

At my knowledge, the schema will not be automatically updated based on changes in the data source. 

ALM Toolkit can detect changes to the schema, but it still requires you to update semantic model manually.

FYI-

https://community.fabric.microsoft.com/t5/Desktop/Auto-publish-to-service-from-desktop-automatically...

Best Regards,

Wearsky

[kunalgupta]

Thanks @v-xiaocliu-msft , for checking this.

is there a way to dynamically create OR recreate data sets from same set of tables and publish them using rest api?

I am thinking like recreate data set with new columns and rebind report. 

Open of any other suggestions too in this regards.

[kunalgupta]

Thanks for reply @lbendlin . Can you help me with the possible way/s to do it?

I definitely need it

[lbendlin]

I want my semantic data model to be udpated with column updates, is there a way to automate this? ( I do not want to do it manually) 

Power Query is extremely sensitive to that.  It will react with "key not found"  errors etc, especially for removals.  You would have to implement a complete CI/CD solution to make this even remotely work, but don't expect it to be a smooth experience at all.