Forum Discussion
Direct Query With Publish to Web (embedded code link) not working
Hi tushartechlab ,
Based on my test, the report can be published to web when it connects to the data source use DirectQuery.
If you want to publish a report with DirectQuery, you will have to have the On-Premise Data Gateway installed.
You would then need to configure the On-Premise Data Gateway with the DirectQuery Data Source.
Once the above is done, you can then upload your Power BI Report. Once it has been uploaded it should notify you that it is connected to the Gateway.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Agreed. Based on my test, the visual will be refreshed after an hour. Yet i haven't found any document but there's some topic about it.
