Direct Query & Data Source Question

[jcampbell474]

We're getting ready to test an app in the service with Direct Query to a PostgresSQL server.  The source table updates real time, so I set the Auto Page Refresh in the PBIX to every 5-seconds.  It's a very light load.  Everything works great.

The question/concern is, when multiple people open it in the App (in the service), will it multiply the number of Direct Query connections to the data source by the number of users.  I don't think it would and the DQ dataset will be open in memory/the service and faciliate all traffic through it.

Can anyone validate my suspicion?

[Daryl-Lynch-Bzy]

Hi @jcampbell474 - Each use will issue a separate SQL call.   Because you are using Direct Query connection, there is no query caching.  However, I can't comment on how PostgresSQL server will handle the similar request.

[jcampbell474]

Replacing my prior reply.  Your statement makes sense and we will test to confirm.  Thank you.