Forum Discussion
Multiple Database Connection in paginated reports
In paginated reports a single query can only go against one data source. So if you have multiple tables in your report and you want one to come from each database then that would work fine. If you want to join across the two databases then a Power BI report would be a better option. Or depending on the data sources you may be able to create a linked server or a view across both databases (if both databases are on the same server)
In paginated reports a single query can only go against one data source. So if you have multiple tables in your report and you want one to come from each database then that would work fine. If you want to join across the two databases then a Power BI report would be a better option. Or depending on the data sources you may be able to create a linked server or a view across both databases (if both databases are on the same server)