Pivot drill-through without database access

I would like to enable the users in the pivot tables to see the details (drill-through) without allowing them to build new queries. This way the settings are correct, but then the employee can only select the number.

The database has the setting "No self-service". If I change that, then he can also see details, but the problem is that he can then also build queries and he shouldn't be able to do that.

Is that possible somehow? So it should be able to see pivot details, but not be able to build queries:

My Version is: v0.49.1
"browser-info": {
"language": "de",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0",
"vendor": ""
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.7+7-LTS",
"java.vendor": "Microsoft",
"java.vendor.url": "https://www.microsoft.com",
"java.version": "17.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.7+7-LTS",
"os.name": "Windows Server 2019",
"os.version": "10.0",
"user.language": "de",
"user.timezone": "Europe/Berlin"
"metabase-info": {
"databases": [
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "16.1"
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.2"
"run-mode": "prod",
"version": {
"date": "2024-03-21",
"tag": "v0.49.1",
"hash": "54ef5e9"
"settings": {
"report-timezone": null


If you remove self service then they will not be able to drill through because when you are drilling through data you are actually creating new questions