Fetching Data directly at runtime

Hi, Is there a way to extract information directly from our Database in runtime (Like DirectQuery)?

Hi Raunak,

Yes, it is possible to extract information directly from your database. This can be achieved by
-> disabling cache
-> by configuring default cache time. (default cache time is 24 hours)

To know more refer, http://www.helicalinsight.com/technical-guide/customizing-cache-memory/

Note:
If you disable cache or reduce cache time will affect application performance in terms of user request fulfillment. We do not recommend such steps to user.

Regards,
Helical Insight Support Team