Share via

OLAPQueryLog is not working for SSAS Tabular mode

Prabu, Chandran 41 Reputation points
2022-12-13T15:40:35.783+00:00

We are facing an issue when we try to setup querylog in SSAS Tabular cubes, it is not capturing any logs. but the same is working fine for MDX cubes.

The QueryLog Table name has been created already, and WRITE permissions on the table has given to the service account used to run SSAS. I've set the QueryLogSampling value to "1", but I'm not seeing anything come through.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
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,343 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,631 Reputation points
    2022-12-14T02:39:44.573+00:00

    Hi @Prabu, Chandran ,
    Query log can be enabled for Analysis Services multidimensional mode instances only. Query log cannot be enabled for tabular mode instances.
    See more: Query logs.
    The link below contains some interesting methods that people have used, and each one has its plus and minus factor depending on your needs: SSAS Tabular Logging Methods.
    Best Regards,
    Joy

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.