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 envir...

General Comment

Need Help

v-frfei-msft
8 years ago
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

v-frfei-msft

Community Support

8 years ago

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

Not applicable

8 years ago

Thank you Frank !

Forum Discussion

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