---
title: "Caching Luminesce query results from BI apps for faster execution"
slug: "caching-luminesce-query-results-from-bi-apps-for-faster-execution"
updated: 2024-08-21T07:15:49Z
published: 2024-08-21T07:15:49Z
canonical: "support.lusid.com/caching-luminesce-query-results-from-bi-apps-for-faster-execution"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.lusid.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Caching Luminesce query results from BI apps for faster execution

You can integrate your BI app with Luminesce to enable end users to query providers from their familiar BI environment as they would any other data source. [Find out more about this](/v1/docs/how-do-i-use-bi-apps-such-as-powerbi-tableau-or-excel-to-interact-with-luminesce).

In some circumstances, you can choose to cache query results (data and/or metadata) so that the same query run by the same user executes more quickly subsequent times.

To turn on caching for an ODBC-aware app such as Tableau or Excel integrated [using the Luminesce ODBC driver](/v1/docs/installing-the-standalone-windows-odbc-driver-to-connect-a-bi-app-to-luminesce), specify the `CacheLevel` and `CacheDuration` parameters in a connection string:

![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/71818b83-a2bb-46b7-be07-bc90ccd4d9cf.png)

To:

- Cache metadata at the process level, set `CacheLevel` to `1` and do not specify the `CacheDuration` parameter. Metadata is held for the lifetime of the process. If there is a cache miss the request to the platform is with platform caching and a one minute duration.
- Cache data at the platform level, set `CacheLevel` to `2` and the `CacheDuration` parameter to an amount of time using the syntax `hh:mm:ss` or `days:hh:mm:ss`, for example `02:00:00` to specify two hours. Cached data is returned for the same query from the same user across any connecting client process, and expires after `CacheDuration`.
- Cache metadata *and* data, set `CacheLevel` to `3` and the `CacheDuration` parameter as above.
- Clear the cache, set `CacheLevel` to `0` or omit the parameter from the connection string.

To turn on caching for Power BI Desktop integrated [using the Luminesce Power BI Connector](/v1/docs/installing-the-power-bi-connector-to-connect-power-bi-desktop-to-luminesce), use the native caching controls:

![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/6e9dc704-b011-44e0-9acf-91b78feb71e5.png)