Cannot download csv or xlsx with empty filters

Hi, we have a dashboard with filters, not all filters have to be filled in to see data, when a user clicks on a question in the dashboard it opens the question with the filters pulling through, when the user tries to download the data in Excel it fails. When I make the user admin (being able to change questions) the filter falls away and only the filters that are active pull through, like when editing a question then the user can download the Excel file. it seems like the browser passes on null values and Metabase does not seem to like this. this is from version 0.46.

here is the error when downloading a CSV:

[8:16 AM] Serrenilla De Wet [ MTN South Africa ]




CSV error - {"via":[{"type":"clojure.lang.ExceptionInfo","message":"Invalid parameter: Card 263 does not have a template tag named nil.","data":{"type":"invalid-parameter","invalid-parameter":{"type":"date/relative","id":"87042003","value":"thismonth","target":["dimension",["field",426287,null]]},"allowed-parameters":null},"at":["metabase.query_processor.card$fn__89310$validate_card_parameters__89315$fn__89316","invoke","card.clj",163]}],"trace":[["metabase.query_processor.card$fn__89310$validate_card_parameters__89315$fn__89316","invoke","card.clj",163],["metabase.query_processor.card$fn__89310$validate_card_parameters__89315","invoke","card.clj",154],["metabase.query_processor.card$run_query_for_card_async","invokeStatic","card.clj",210],["metabase.query_processor.card$run_query_for_card_async","doInvoke","card.clj",172],["clojure.lang.RestFn","invoke","RestFn.java",826],["metabase.api.card$fn__90203","invokeStatic","card.clj",786],["metabase.api.card$fn__90203","invoke","card.clj",778],["compojure.core$wrap_response$fn__42375","invoke","core.clj",160],["compojure.core$wrap_route_middleware$fn__42359","invoke","core.clj",132],["compojure.core$wrap_route_info$fn__42364","invoke","core.clj",139],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",151],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",152],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387","invoke","core.clj",200],["metabase.server.middleware.auth$enforce_authentication$fn__86624","invoke","auth.clj",17],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387","invoke","core.clj",200],["compojure.core$make_context$handler__42415","invoke","core.clj",290],["compojure.core$make_context$fn__42419","invoke","core.clj",300],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$make_context$fn__42419","invoke","core.clj",301],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$make_context$fn__42419","invoke","core.clj",301],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$make_context$fn__42419","invoke","core.clj",301],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$make_context$fn__42419","invoke","core.clj",301],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["metabase.api.routes$fn__98449$fn__98452","invoke","routes.clj",64],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387","invoke","core.clj",200],["clojure.lang.AFn","applyToHelper","AFn.java",160],["clojure.lang.AFn","applyTo","AFn.java",144],["clojure.core$apply","invokeStatic","core.clj",667],["clojure.core$apply","invoke","core.clj",662],["metabase.server.routes$fn__98610$fn__98611","doInvoke","routes.clj",70],["clojure.lang.RestFn","invoke","RestFn.java",436],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387","invoke","core.clj",200],["compojure.core$make_context$handler__42415","invoke","core.clj",290],["compojure.core$make_context$fn__42419","invoke","core.clj",300],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["compojure.core$wrap_route_matches$fn__42368","invoke","core.clj",153],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387$f__42388$respond_SINGLEQUOTE___42389","invoke","core.clj",197],["metabase.server.routes$fn__98595$fn__98597","invoke","routes.clj",47],["compojure.core$routes$fn__42387$f__42388","invoke","core.clj",198],["compojure.core$routes$fn__42387","invoke","core.clj",200],["metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__95133","invoke","exceptions.clj",103],["metabase.server.middleware.exceptions$catch_api_exceptions$fn__95130","invoke","exceptions.clj",91],["metabase.server.middleware.log$log_api_call$fn__100334$fn__100335$fn__100336","invoke","log.clj",216],["metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info","invokeStatic","diagnostic.clj",18],["metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info","invoke","diagnostic.clj",12],["metabase.server.middleware.log$log_api_call$fn__100334$fn__100335","invoke","log.clj",208],["toucan2.execute$do_with_call_counts","invokeStatic","execute.clj",112],["toucan2.execute$do_with_call_counts","invoke","execute.clj",103],["metabase.server.middleware.log$log_api_call$fn__100334","invoke","log.clj",207],["metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__103755","invoke","browser_cookie.clj",42],["metabase.server.middleware.security$add_security_headers$fn__79453","invoke","security.clj",153],["metabase.server.middleware.json$wrap_json_body$fn__102499","invoke","json.clj",69],["metabase.server.middleware.offset_paging$handle_paging$fn__79477","invoke","offset_paging.clj",45],["metabase.server.middleware.json$wrap_streamed_json_response$fn__102517","invoke","json.clj",103],["ring.middleware.keyword_params$wrap_keyword_params$fn__104022","invoke","keyword_params.clj",55],["ring.middleware.params$wrap_params$fn__104041","invoke","params.clj",77],["metabase.server.middleware.misc$maybe_set_site_url$fn__50479","invoke","misc.clj",61],["metabase.server.middleware.session$reset_session_timeout$fn__63769","invoke","session.clj",430],["metabase.server.middleware.session$bind_current_user$fn__63739$fn__63740","invoke","session.clj",336],["metabase.server.middleware.session$do_with_current_user","invokeStatic","session.clj",315],["metabase.server.middleware.session$do_with_current_user","invoke","session.clj",304],["metabase.server.middleware.session$bind_current_user$fn__63739","invoke","session.clj",335],["metabase.server.middleware.session$wrap_current_user_info$fn__63721","invoke","session.clj",285],["metabase.server.middleware.session$wrap_session_id$fn__63704","invoke","session.clj",217],["metabase.server.middleware.auth$wrap_api_key$fn__86632","invoke","auth.clj",30],["ring.middleware.cookies$wrap_cookies$fn__103942","invoke","cookies.clj",216],["metabase.server.middleware.misc$add_content_type$fn__50461","invoke","misc.clj",29],["metabase.server.middleware.misc$disable_streaming_buffering$fn__50487","invoke","misc.clj",78],["ring.middleware.gzip$wrap_gzip$fn__103984","invoke","gzip.clj",86],["metabase.server.middleware.misc$bind_request$fn__50490","invoke","misc.clj",95],["metabase.server.middleware.ssl$redirect_to_https_middleware$fn__103771","invoke","ssl.clj",41],["metabase.server$async_proxy_handler$fn__99100","invoke","server.clj",77],["metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a","handle",null,-1],["org.eclipse.jetty.server.handler.StatisticsHandler","handle","StatisticsHandler.java",173],["org.eclipse.jetty.server.handler.HandlerWrapper","handle","HandlerWrapper.java",122],["org.eclipse.jetty.server.Server","handle","Server.java",563],["org.eclipse.jetty.server.HttpChannel","lambda$handle$0","HttpChannel.java",505],["org.eclipse.jetty.server.HttpChannel","dispatch","HttpChannel.java",762],["org.eclipse.jetty.server.HttpChannel","handle","HttpChannel.java",497],["org.eclipse.jetty.server.HttpConnection","onFillable","HttpConnection.java",282],["org.eclipse.jetty.io.AbstractConnection$ReadCallback","succeeded","AbstractConnection.java",314],["org.eclipse.jetty.io.FillInterest","fillable","FillInterest.java",100],["org.eclipse.jetty.io.SelectableChannelEndPoint$1","run","SelectableChannelEndPoint.java",53],["org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy","runTask","AdaptiveExecutionStrategy.java",416],["org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy","consumeTask","AdaptiveExecutionStrategy.java",385],["org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy","tryProduce","AdaptiveExecutionStrategy.java",272],["org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy","lambda$new$0","AdaptiveExecutionStrategy.java",140],["org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread","run","ReservedThreadExecutor.java",411],["org.eclipse.jetty.util.thread.QueuedThreadPool","runJob","QueuedThreadPool.java",936],["org.eclipse.jetty.util.thread.QueuedThreadPool$Runner","run","QueuedThreadPool.java",1080],["java.lang.Thread","run","Thread.java",832]],"cause":"Invalid parameter: Card 263 does not have a template tag named nil.","data":{"type":"invalid-parameter","invalid-parameter":{"type":"date/relative","id":"87042003","value":"thismonth","target":["dimension",["field",426287,null]]},"allowed-parameters":null},"message":"Invalid parameter: Card 263 does not have a template tag named nil.","invalid-parameter":{"type":"date/relative","id":"87042003","value":"thismonth","target":["dimension",["field",426287,null]]},"allowed-parameters":null}

Here is the details from troubleshooting

{
  "browser-info": {
    "language": "en-GB",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "14.0.1+7",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "https://java.oracle.com/",
    "java.version": "14.0.1",
    "java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
    "java.vm.version": "14.0.1+7",
    "os.name": "Windows Server 2016",
    "os.version": "10.0",
    "user.language": "en",
    "user.timezone": "Africa/Johannesburg"
  },
  "metabase-info": {
    "databases": [
      "oracle",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "10.12"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.1"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-03-28",
      "tag": "v0.46.0",
      "branch": "release-x.46.x",
      "hash": "0ca7df3"
    },
    "settings": {
      "report-timezone": "Africa/Harare"
    }
  }
}

Can you share some screenshots to explain the process and maybe replication steps using the Sample Database which comes with Metabase