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 on the web, but when i refresh the web page on the browser the data are not updated. The web page show me the latest data updated manually on PowerBI Desktop.

 

I thought that everytime that i refresh the page, the query will update the data n the browser, but it doesn't works.

How can i do to connect the web page directly to the server?

 

Thanks

Bye

 

Lorenzo

3 Replies

    • Lorian's avatar
      Lorian
      Advocate 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Any news here?

    I think the queries are still not being transfered directly from the web version to the Server connected via DirectQuery, right?

    Any way to make this work?