Forum Discussion
How extract information from different SQL Server instances
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/
Hi Greg, thanks
I have one report done and it is connected to one single SQL Server instance until here everything works well.
Now I need to extract the same report with different instances into my on-premises servers, the question is I need to copy and paste twenty times the same pbit file or pbix file? Also, I need to maintain the information in the cloud refreshed to admin purposes.
Regards;
Jairo Suarez