Managing Dev,Test and Prod Environments in Power BI Desktop.

[Anonymous]

Hi Everyone,

Being a newbie, I need help to understand if there are any best practises when it comes to working with several environments.

Is it recommended to build your reports in all environments ?

If yes, is it recommended to build your reports manually in all environments or are there any possibilities to "transfer" from DEV to TEST for example ?

Any other tips/comments are welcome.

Thank you!

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

You can build your reports in different environments and you can transfer from Dev to test or prod by using data source parameter.

Then we can get data using the Parameter that we created. In power query we can get different data of different environment by changing the Current value.For more details, please check the online document.

Here is the M code in power query for your reference.

let
    Source = Sql.Databases(Parameter1),
    Power_BI_Test = Source{[Name="databasename"]}[Data],
    dbo_Financial_1 = databasename {[Schema="dbo",Item="Financial_1"]}[Data]
in
    dbo_Financial_1

Regards,

Frank

[Anonymous]

I doubt this something you can do only for Import mode and Not on Direct Query. 

[HalloWorld]

You cannot make new columns since that will ask you to import all tables:

Yet, you can get around that a bit. Write as much as you can in the sql query (and do the rest in DAX measures perhaps):

= Sql.Database(environment, "testDB", [Query="select * from dbo.test"])

(I tested a bigger query as well). Then, you need to agree to run a native database query:

After that, close by taking over the change:

And your model will be parametrized with the value that you chose, and you can change it again in the "Transform data" tool:

[Anonymous]

Thank you Frank !