Forum Discussion

syairdafiq's avatar
syairdafiq
New Member
1 year ago
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...
  • manvishah17's avatar
    1 year ago

    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