Hello.
I tried this approach a few days ago, and the parameters work fine on my local machine using my token databricks. I got the expected result after run the query.

The main issue is that I'm building this object to be published on Power BI Report Server, which only supports connections to Databricks via an ODBC driver.
After publishing the object, I’m able to switch the connection to ODBC, test it successfully, and I can also see the parameters. However, when executing the query, it returns an error.

Testing odbc connection (ok):

checking my parameters (ok)

opening the report (ok)

Runnin the report (not ok)

I have tried many configurations, but I'm still have trouble.
Thanks for the suggestion.