Forum Discussion
ElpatoDBA
Helper II
Helper IIHow extract information from different SQL Server instances
Hi community. I have finished up my report but I have more than 20 instances on-premises databases. I wondering if exists any procedure to extract from the same file pbix or pbit file the info fr...
ElpatoDBA , You want append data from 20 Connection or change connection and check.
If this looking to the same data you can change the connection using edit datasources for the same version.
Check here same type and different type of data source using edit query
https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/
amitchandak
Super User
Super UserElpatoDBA , You want append data from 20 Connection or change connection and check.
If this looking to the same data you can change the connection using edit datasources for the same version.
Check here same type and different type of data source using edit query
https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/