Forum Discussion
Solved
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 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/
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