DataConnectors icon indicating copy to clipboard operation
DataConnectors copied to clipboard

Parameter binding still enabled after setting SQL_API_SQLBINDPARAMETER = false

Open xsgao-github opened this issue 6 years ago • 3 comments

I am using samples\ODBC\SqlODBC as my project template. In line 62 of SqlODBC.pq, Config_UseParameterBindings is set to false, thus these lines (287 - 289) should set SQL_API_SQLBINDPARAMETER to false as well:

                    SQLGetFunctions = [
                        SQL_API_SQLBINDPARAMETER = false
                    ]

However, Power BI still sends me query with parameter binding, e.g.

select top 501 "Year" from ( select "Year", "C1", case when "C1" is not null then { fn convert("C1", SQL_DOUBLE) } else ? end as "C2", case when "C1" is null then ? else ? end as "C3" from ( select "Year", "Year" as "C1" from "GO Sales (query)"."Sales (query)"."Time" ) as "ITBL" group by "Year", "C1" ) as "ITBL" order by "ITBL"."C2", "ITBL"."C3"

I am sure my .mez is deployed correctly because every other changes I made will take effect in Power BI.

My Power BI Desktop build is: Version: 2.58.5103.501 64-bit (May, 2018)

xsgao-github avatar May 29 '18 17:05 xsgao-github