Connect to multiple tables on the same SQL server using data gateway
Apologies if this has been asked before, I am trying to connect to multiple tables on the same SQL server. My report contains two queries, both referencing two different tables on the same server. THese run fine both within SQL and in the report. I'm trying to set up the report for a scheduled refresh using the data gateway, however I can't get it to connect. This worked fine when I was just referencing the one table but it won't connect to the second table. I've tried adding it in Manage Gateways with no luck. What am I doing wrong? Thank you.