szymon_dybczak
Esteemed Contributor III

Hi @IONA ,

You can parametrize your data source using power query parameters. Just define parameter for catalog, schema etc. 

I have such setup in one of the project. We parametrized our PBI semantic models and when we are deploying semantic model to a higher environment we are using parameters to automate entire process (using pbi deployment pipelines)

You can check following article for reference: 

https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

https://www.rigordatasolutions.com/post/swap-data-sources-dynamically-using-parameters-in-power-bi

Hi @IONA ,

You can parametrize your data source using power query parameters. Just define parameter for catalog, schema etc. 

I have such setup in one of the project. We parametrized our PBI semantic models and when we are deploying semantic model to a higher environment we are using parameters to automate entire process (using pbi deployment pipelines)

You can check following article for reference: 

https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

https://www.rigordatasolutions.com/post/swap-data-sources-dynamically-using-parameters-in-power-bi

In your case you can decouple power bi reports from schema in exactly the same way - using parameters.