Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Filtering caching related queries from on-prem SSAS trace

Hi there!   We have a very nice dashboard providing usage statistics of an on-prem SSAS instance. The instance is being used in the Power BI Service, exposing it using the On-Prem Data Gateway.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi!


I'm not completely sure what you mean, the 'certificate' term you're using is a bit confusing :).

In my experience - for SSAS live connections - it's always the report user effectiveusername that's send to SSAS (not the owner or user who shared the report).

But maybe you're not talking about SSAS connections?

 

However, this is not related to my question? Or maybe I completely misunderstand you.

I see query events in the trace, and can't distinguish between actual user interactions and cache-related queries..

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

>>However, this is not related to my question? Or maybe I completely misunderstand you.
Sorry, it seems like I have misunderstand your requirement.

 

>>I see query events in the trace, and can't distinguish between actual user interactions and cache-related queries..
I think these queries are generate by power bi desktop.

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    >> I think these queries are generate by power bi desktop.

    Since Power BI Desktop is not 'in scope' of this situation, I don't think so.

     

    Has anyone found a solution yet?

    Please reply here if you also encounter this issue, so the MSFT team sees how big this issue is :).