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

[lorenzolancio]

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

[Anonymous]

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?

[quentin_vigne]

Hi @lorenzolancio

With DirectQuery the data refresh every hour.

It can takes time to refresh for the service sometimes

- Quentin

[Lorian]

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.