How to track users usage?

ovonemty 31 Reputation points

I am trying to track users using my Power BI reports. I started using the data provided by microsoft:

But unfortunately, most of my users access it, within Teams, so I cannot really track them...

I am trying to go when level deep since Power BI is unable to track users coming from Teams...

I just need a monthly list of the users accessing the cube, is there a way I can pull that??

I have 4 cubes in my instance:

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,102 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,246 Reputation points

    Hi @ovonemty ,

    Here is a similar thread for you: How to track the users inforamtion who all are accessing SSAS cube.
    According to your screenshot, Server mode is Tabular. Query log can be enabled for Analysis Services multidimensional mode instances only. Query log cannot be enabled for tabular mode instances.
    Use ASTrace, rather than a query log, to find out who is querying cubes. The query log is typically used to provide input into the Usage Based Optimization Wizard, and the data it captures is not easy to read or interpret. ASTrace is a community tool, widely used, that captures query operations. You can also use SQL Server Profiler, xEvents, or an Analysis Services trace.

    Microsoft document:

    Best regards,

    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.

    0 comments No comments