Report model data source Does anybody know how i could use a linked server as a data source for a report model in SQL server 2008 r2? or how i could make this linked server a data source on a report model? Please help. Thank you.
Why not just put the datapull for the linked data source in a stored procedure and then access it from a "local" database?