check if cube is used?

[ovonel]

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…)

[v-easonf-msft · Accepted solution]

Hi,  @ovonel 

Are these reports created and published by you locally?
Maybe you can check  'Global permissions' of these cubes held on your local computer in 'Data source settings'.

You can also try the Rest API to get all the data sources in each dataset.

Please refer to this related thread.

how to fetch all Datasources for all Datasets 

---

get all workspaces which you have access to:

https://docs.microsoft.com/en-us/rest/api/power-bi/groups/getgroups

Loop through all workspaces and for each workspace get all datasets :

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasetsingroup

And then for each dataset get all datasources : 

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup

---

Best Regards,
Community Support Team _ Eason

[amitchandak]

@ovonel , we usually use DAX studio to check unused measure. See if that can help in this case too

https://ssbi-blog.de/blog/technical-topics-english/how-to-identify-measures-not-used-in-your-pbix-fi...