check if cube is used?

Question

Hi all,

I have a legacy SSAS engine:

With around 20 cubes…

Is there any way to check which are currently being used by power bi reports?

That is, can I have some sort of trace or query where I can confirm if the cube has been queried and/or connected from any powerbi/cube?

If not? What’s a proper way of checking this? (as a plan B I thought of renaming the cubes to %_ToBeDeleted, and wait for a powerbi/ excel consumption to break…)

Answer 1

Hi @ovonemty ,

Welcome to Microsoft Q&A!

can I have some sort of trace or query where I can confirm if the cube has been queried and/or connected from any powerbi/cube?

You could check the information using Dynamic Management Views.

The last processed date:

Current users:

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

There are a lot of ways to track cube usage: https://learn.microsoft.com/en-us/analysis-services/instances/monitor-an-analysis-services-instance?view=asallproducts-allversions
The problem is, tracking usage won't let you uncover dormant consumers, so you should probably take a step back and consider your end goal, which is likely a decision whether to retire this legacy. Generally speaking, legacy systems are safe to retire when either they are of no further value or when their value can also be obtained elsewhere, usually from a newer system.