Forum Discussion

kunalgupta's avatar
kunalgupta
Regular Visitor
1 year ago

Schema update post addition/deletion in data source

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!

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    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.

  • kunalgupta's avatar
    kunalgupta
    Regular Visitor
    1 year ago

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

    I definitely need it

    • kunalgupta's avatar
      kunalgupta
      Regular Visitor
      1 year ago

      Thanks Anonymous , 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.