Power BI report extension

[Anonymous]

Hi All,

We are having several reports built on SQL Server connection. As part of project, we need to extend the reports to other factories. 

For each factory, we have a dedicated database so currently we extend the reports after making changes in "Data Source" setting of edit queries.

But the issue is, whenever we are making any change in report, we need to do the same steps to replicate the changes for all factories. Do we have any better solution than the one I am using (Datasource stting change) currently?

Thank you,

Niket Talati

[v-yuezhe-msft · Accepted solution]

@Anonymous,

You can create a database parameter in Power BI Desktop, and then use the parameter in Advanced Editor of your query, for more details, please review my reply in the similar thread below.

https://community.powerbi.com/t5/Integrations-with-Files-and/Import-Data-from-Multiple-Data-Source-and-Servers/m-p/515279#M19763

Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@Anonymous,

You can create a database parameter in Power BI Desktop, and then use the parameter in Advanced Editor of your query, for more details, please review my reply in the similar thread below.

https://community.powerbi.com/t5/Integrations-with-Files-and/Import-Data-from-Multiple-Data-Source-and-Servers/m-p/515279#M19763

Regards,
Lydia

[Anonymous · Accepted solution]

@v-yuezhe-msft

Thank you, it worked!

Regards,

Niket Talati