How to track users usage?

ovonemty 51 Reputation points
2022-11-18T08:58:00.17+00:00

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

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics#frequently-asked-questions

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:
261789-image.png

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,244 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,436 Reputation points
    2022-11-21T02:28:11.367+00:00

    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: https://learn.microsoft.com/en-us/analysis-services/instances/log-operations-in-analysis-services?view=asallproducts-allversions#bkmk_querylog

    Best regards,
    Seeya

    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