Forum Discussion

lorenzolancio's avatar
lorenzolancio
Frequent Visitor
8 years ago

Publish to web real-time with Direct Query on SQL server

Hello there :) I have connected a a SQL Server Database with 'On-permises Data Gateway' and i used DirectQuery to get a data table from the database. Now i would like to publish a real-time report ...
quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

Hi lorenzolancio

 

With DirectQuery the data refresh every hour.

It can takes time to refresh for the service sometimes

 

- Quentin

  • Lorian's avatar
    Lorian
    Icon for Advocate II rankAdvocate II
    8 years ago

    Hi Quentin,

     

    I'm not understanding what you're saying.

     

    If I connect to the server using Import, I can then create a Refresh Schedule to run that query. But DirectQuery doesn't work on Refresh Schedules. So what do you mean by "With DirectQuery the data refresh every hour"?

    My understanding of a DirectQuery is that it is a live connection to the server which should run the query when you at least open or refresh the book?

     

    This is in the Report Server part of the forum, so not using the cloud Service.