Discourse Data Explorer

You can set a group that can run the query. It’s in the settings for every wuery.

Yes after allowing the group, how a user in that particular group can run the query. They don’t see the plug-ins. From where do they find the query

Send them the link to the query.

Have you tried it as a regular user?

The report is shown in the reports section of that group.
{yoursite}/g/{group}/reports