Direct Query With Publish to Web (embedded code link) not working

Thankyou guys,

I guess I figured out the problem. Everything was configured properly, but once I publish the report I have to go to data connections and reconfigure / map the data source to the gateway again, somehow it gets unmapped. I guess it is due to the "replace" option that I am selecting when deploying from local to the server from desktop. 

But I see that in direct query the reports in normal mode do show real-time data but the publish to web (embed code) reports don't show real-time data, I guess they still follow the caching mechanism in the direct query mode too, as mentioned on the Microsoft Website. So I guess it show the database changes after an hour? What are your thoughts guys?

Thanks for the response guys.