Forum Discussion

fala70's avatar
fala70
Regular Visitor
5 years ago

DirectQuery with Gateway using SQLServer

Hi, I've problems to show data using DirectQuery, when I publish dashobard.   I installed the gateway on my server where is present an instance of SQLServer database, same instance used to design t...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

First off - it is not advisable to install the gateway on a machine that is used for something else.  The gateway cluster members should be independent and dedicated VMs with lots (LOTS) of cores and decent memory and disk size - IF you use the gateway for dataset mashups.

 

Direct Query means that the gateway "only"  acts as a passthrough.  In this case network performance becomes much more important on both the gateway and on the database server machine.  In addition you need to make sure that your database server can actually handle the onslaught of the thousands of little queries. So better have your indexes and statistics in order etc.

 

Now to your question - Is the SQL server connection your only data source, or do you have other data sources in your direct query data model too?

  • fala70's avatar
    fala70
    Regular Visitor
    5 years ago

    My main goal is have a dashboard where data and charts are update automatically each hour. If I understood good, to have chart where are update automatically, without run refresh browser, is use directy query. No at the moment I've ony my data source with 2 dashbaord, one use directy query and other use import data.

    If there are other modes to update charts automatically without refresh manually browser are welcome