Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
458 questions
Identifying Unused Tables in AAS Cube Over the Last 30 Days
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
madmax
0
Reputation points
I have a question regarding identifying unused tables in Azure Analysis Services (AAS).
In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used in the last 30 days. Our AAS model is utilized in some SSRS reports, in Power BI reports (which are scheduled for daily refresh), and is also directly queried via SSMS.
Could someone guide me on how to identify tables within the AAS cube that haven't been used in the past 30 days?
Sign in to answer