Value.NativeQuery() with Azure Databricks

Looking for guidance on Power Query connecting to Azure Databricks using Value.NativeQuery()

I have read in other posts that Value.NativeQuery() will not work becuase Azure Databricks does not support native queries.  However, I know Databricks supports native queries as I was able to implement this: https://learn.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#using-a-custom-sql-queryhttps://lnkd.in/gcFM_bNA

The above creates a function that allows you to paste in the desired sql statement. However, it does not allow subsequent applied Power Query steps to be folded.

I want to use Value.NativeQuery() so that the subsequent applied Power Query steps can fold back to Databricks.

I have tried multiple approaches and always receive the below error.
Below are the approaches I have tried, with variations of each. I used ||Pipe|| to mask names. Hoping someone can spot an error in my syntax?  Or insights why 1 method of Native Queries works but not the Value.NativeQuery()?