Forum Discussion
Combining and publishing data from multiple workspaces.
All connections that pull data from a source require a gateway (live or import) so if you look at the gateway setup where the live report is working you would see the server that is the target of the live query. You would need to add that source the whatever gateway is supplying your new report.
Hi jdbuchanan71 ,
I'll take a deeper look into this.
The used sources are being refreshed over different gateway's as well..
Will post if the assigning of a gateway works and is the solution.
Hi jdbuchanan71 ,
So far i'm unalbe to add the second source to the gateway.
I'm also running into problems again with other reports that re-use datasets the are published in the service (even ones that are published to the same workspace and use the same gateway for the first source).
It's a shame this is throwing so many problems.
Perhaps raising a ticket at MS could help resolve this?
