- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 10:49 PM
Here is the resolution I got from Databricks support:
"The reason they changed the default value of EnableNativeParameterizedQuery to 0 in v2.8 is that Databricks DBSQL server does not support Prepare when using native parameterized queries, so SQLPrepare will have a regression if the Native parameterized query is turned on by default and used by Power BI. The PG team also noticed that you’ve also turned on the UseNativeQuery. If you can turn off this (set UseNativeQuery=0), then it should also fix the issue even if they do not set EnableNativeParameterizedQuery=1 . Please note EnableNativeParameterizedQuery=1 was enabled in v2.7.3, before that, the query will also break if UseNativeQuery=1 "
hope this helps..