Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Add ability to switch model source tables to new warehouses/lakehouses/connections

I want to switch/edit model file source tables to a new warehouse from an existing one without having to recreate a new model file connected to a new warehouse and start over.  Power BI models seem to allow edit data connection strings.  I already have reporting built on top of the model file but the data is moving from the source warehouse of the current model.  And moving workspaces eventually.

 

Edit tables or edit model feature doesn't suggest the source location change like Data Flows and Copy Jobs can  (workspace/onelake/lakehouse/warehouse) after its already created.  It appears to be hardcoded to the warehouse.  It only the tables already loaded from a source.  I want to move the underlining data to new lakehouses/warehouses/workspaces due to new architecture/consolidation/reorgs owning new data objects and naming conventions and not have to rebuild a new model to support it.  It appears functionality doesn't exist for modifying an existing model sources in fabric in the model builder or warehouse model layout.  

Status: New