Forum Discussion
How 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 from my 20 SQL Server instances.
Note: My SQL Server servers are different flavours of SQL.
I will really appreciate your help if someone has done the same.
Regards;
Jairo Suarez
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/
7 Replies
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/
ElpatoDBA - Sorry, not sure what you mean. You can connect to all of those SQL Servers in a single Power BI file. Sorry, can you explain in more detail what you are trying to do?
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
