Configuration for Data Sources

[dday9]

In some of my Power BI reports I am implementing a CTE when importing my data, as a result I'm referencing the database; the database that I'm referencing is the developer database. Is there something that I can implement, like an appsettings.config file, that allows for us to reference the developer database, or the quality assurance database, or the production database so that when we go into production there is a seemless transition?

[Jayendran]

Hi @dday9 

Not sure this helps but worth to try of PowerBI Parameters

See the below reference too

https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-par...

[dday9]

Thank you @Jayendran for the article, but it doesn't look like it quite fits my use case. I was able to setup the parameter and reference it in the "Database" field of "Get Data" but I wasn't able to reference it from the "Advanced Options" field which is where I was specifying the data source in my CTE.