Forum Discussion
Power BI report extension
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
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
2 Replies
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