Forum Discussion
Solved
Reuse Semantic Model Logic in Power BI
Hi, I’d like to ask about duplicating a semantic model in Power BI. Here’s my case: I have two partner categories, Partner A and Partner B. Each partner has its own data source. I’ve already create...
Hi syairdafiq ,
To effectively reuse your semantic model logic for Partner A and Partner B with different data sources, you can create a parameterized data source in Power BI. This involves creating a parameter in Power Query to represent the partner name or data path, and then using that parameter in your query's source step. By doing so, you can dynamically switch between data sources without rebuilding your model. All calculated columns, measures, and visuals built on this query will automatically adapt when the parameter value changes.
Power Query - Using parameters
lbendlin
Super User
Super UserIf the table and column names are the same you can copy/paste between the reports. If you want a copy of the semantic model then save it under a different name.