Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Bind parameter error while using advanced editor in Power BI Desktop (import mode) #651

Closed
rupal-bq opened this issue Jul 31, 2020 · 0 comments

Comments

@rupal-bq
Copy link
Contributor

Loaded data into Power BI Desktop using import mode successfully.

Used following query in Transform Data > Advanced Editor

let
    Source = OdfeSqlOdbcPBIConnector.Contents("localhost", 9200),
    kibana_sample_data_flights_null_null = Source{[Item="kibana_sample_data_flights",Schema=null,Catalog=null]}[Data],
    test_and = Table.SelectRows(kibana_sample_data_flights_null_null, each [OriginWeather] = "Rain" and [OriginCountry] = "CA" ) 
in
    test_and

But got following error while applying the changes.

image

SQL.LOG shows following error

Microsoft.Mashu 20c0-463c	EXIT  SQLBindParameter  with return code -1 (SQL_ERROR)
		HSTMT               0x000001DCA0A0BDA0
		UWORD                        1 
		SWORD                        1 <SQL_PARAM_INPUT>
		SWORD                       -8 <SQL_C_WCHAR>
		SWORD                       -9 <SQL_WVARCHAR>
		SQLULEN                    4
		SWORD                        0 
		PTR                0x000001DCBAF424A8
		SQLLEN                    16
		SQLLEN *            0x000001DCBAF424A0
		DIAG [HYC00] Elasticsearch does not support parameters. (10) 
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant