Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

monitor, evaluate and override user query

is it possible for an administrator to monitor, evaluate and overrride user generated queries in power bi?
Need Help
  • BhavinVyas3003's avatar
    BhavinVyas3003
    1 year ago

    Hi,

    Yes, in Power BI you can monitor and evaluate user queries to some level.
    Admins can use tools like Power BI Activity Logs, Performance Analyzer, and Azure Log Analytics (if using Premium) to check which reports users are using and how queries are performing.

    But you cannot directly override user queries.
    You can control what users can see or use by applying Row-Level Security (RLS), predefined measures, and limited visuals.

    For advanced monitoring, tools like DAX Studio or SQL Profiler can also be helpful.

    Thanks,

    Bhavin

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Yes, it is possible for an administrator to monitor, evaluate, and override user-generated queries in Power BI. Administrators can use various tools and features within Power BI and Azure to achieve this:

Power BI Admin Portal: Administrators can monitor usage metrics, audit logs, and dataset refreshes. They can also manage user permissions and access to datasets and reports.

Query Diagnostics: Power BI provides query diagnostics tools to help administrators understand and optimize the queries being run.