Reuse Semantic Model Logic in Power BI

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