Home Forums Reporting Services Reporting Services How to use two different datasets (from DBs on different servers) in one SSRS Report without Linked Servers RE: How to use two different datasets (from DBs on different servers) in one SSRS Report without Linked Servers

  • October 2, 2015 at 9:03 am

    #1831075

    Koen Verbeeck (10/2/2015)

    The problem is, you can only reference one dataset in an object.

    In other words, you can only link a chart or tablix to one single dataset.

    The straightforward solution would be to put the data into one common location.

    Maybe use Power Query to combine the data sets and dump the results in an Excel file?

    Hi koen,

    The data is live and gets changed throughout the day, hence me wanting to query both server DBs where they are.

    I can't do Openrow or opensource queries because I do not have permissions.

    I can individually query both Servers so have the credentials, but can't use one query to do this....

    Obviously we don't allow linked servers, so how else can I do this? I don't want to use text files etc, but be in tables etc.

    Thanks