Can SSRS cached shared-datasets be accessed from backend database table?

Question

Is the cached dataset available inside the SSRS TempDB or anywhere in the database?

This way, the cached SSRS datasets can be accesssed from backend DB, instead of web portal

So need only to execute 1-time DB query, and subsequent accesses will be from the cached dataset in the DB

Answer 1

Hi @MrCool,

The cached SSRS datasets can be accesssed from backend DB, instead of web portal

The dataset cannot be stored in database, so you cannot access from backend DB.

You may consider using view or stored procedure.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.