cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
thomaslecurieux Frequent Visitor
Frequent Visitor

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @thomaslecurieux,

 

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

 

d1.png

 

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.

 

d2.pngd3.png

 

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

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

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

Hi @thomaslecurieux,

 

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

 

d1.png

 

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.

 

d2.pngd3.png

 

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

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thomaslecurieux Frequent Visitor
Frequent Visitor

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

Thank you Frank !