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
ElpatoDBA , if if these can help
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
Hi
Seems like that last post is the thing that I am looking for. I going to start to read and will back to you and let you know. For now 1M of thanks.
Regards;
Jairo Suarez