Forum Discussion
ODBC Firebird Error - BIGINT not supported
Hi there,
I try to connect to database on Firebird.
When I pull out data I see there is a problem with QUANTITY column in my SQL statement. In some reasons database creator has set up QUANTITY column as BIGINT even though from obvious reasons numbers in that column won't be that big.
If I'm not wrong it says that in some weird resons Power BI cannot read BIGINTs?
Is there a way to avoid that error? I've tried SQL's FORMAT, CONVERT but nothing helped.
I'd like to try everything before speaking with database admin and try to convince him to change column types. I read little about it and it isn't that straightforward.
DataSource.Error: ODBC: ERROR [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -206
Column unknown
QUANTITY
Client SQL dialect 1 does not support reference to BIGINT datatype
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=ESYSTEM
OdbcErrors=[Table]
1 Reply
- v-yanjiang-msft
Community Support
Hi peter_gorgol ,
Please see if this solution can help:
Client SQL dialect 1 does not support reference to BIGINT datatype · Issue #19 ·
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.