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

3 Replies

  • 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.

  • BhavinVyas3003's avatar
    BhavinVyas3003
    Icon for Super User rankSuper User
    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

  • v-hashadapu's avatar
    v-hashadapu
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi powerbiexpert22 , Thank you for reaching out to the Microsoft Community Forum.

    Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
    Thank you.