Switching Data Source by Parameter in Power Service didn't work.

[noreen_41380]

We have two environments, which are PROD and DEV, and these environments have different data sources. Switching environments in Power Desktop works, but in Service it doesn't. We are using Amazon Redshift, does this connection work in parameters?

[arvindsingh802]

have you tied configuring the parameters and using that as value in your power query ?
you can refer https://community.fabric.microsoft.com/t5/Desktop/Parameter-Setting-for-Data-Source-Snowflake/m-p/24... for a walkthrough.

[noreen_41380]

Does this work on the Power BI Service?

[noreen_41380]

Yes, it was already called in Power Query.