Forum Discussion
Change Source Table in a Fabric Semantic Model
We want to change the source of a table in a fabric semantic model. Same table structure but a different instance of it. In traditional Power BI, you would edit your query, go to the source, and change the SQL query. With Fabric, there doesn't seem to be a way to edit the source once the model is built. All I can see is delete, then re-add. The problem is that you would loose any DAX measures created in the table. I've seen mention of using a deployment parameter, but that will not work here as this was not a predictable change, its a one time thing to change the source, but it often occurs with different models.
2 Replies
Hi paivers
Why not move the measures to a different table from your current table.
Then in Fabric I would either create the new table or overwrite the existing table. I would then go into the DirectLake semantic model and either add in the new table or refresh it to get the new columns in the existing table.
The measures should continue to work after the above has been done?
Gilbert, mainly becuase I didn't know how, but someone just mentioned the "Home Table" property on a measure, and you would have to change any mention of the table in filters. Certainly not as easy as having the source expression in Power Query. Is there an easier way than this?
