Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Firebird query fails

Hey All,

I have a long and ugly query.

When I run it directly on the Firebird DB, it works well and I am getting the relevant expected results.

When I use it in Power BI, I am getting an error:

Details: "ERROR [HY000] [ODBC Firebird Driver][Firebird]arithmetic exception, numeric overflow, or string truncation
string right truncation"

2019-05-27 16_32_21-Window.png

 

How can I resolve this?
Where should I start?

 

Cheers!
A

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

I found the problematic part.

 

I have a few lines of 'CASE'.

 

case when
field1 is not null then cast(field1 as varchar(11)) else null end field1,
case when
field2 is not null then cast(field2 as varchar(11)) else null end field2,
etc...

I removed the CAST function and then Power BI started to work as expected and retreive the data

case when
field1 is not null then field1 else null end field1,
case when
field2 is not null then field2 else null end field2,
etc...

Hope it wont cause issues in the future.

 

Any idea why it is not working with 'CAST'?

Cheers!

 

View solution in original post

Hi @Anonymous 

As searched, there may be several reasons as said in this document.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

I found the problematic part.

 

I have a few lines of 'CASE'.

 

case when
field1 is not null then cast(field1 as varchar(11)) else null end field1,
case when
field2 is not null then cast(field2 as varchar(11)) else null end field2,
etc...

I removed the CAST function and then Power BI started to work as expected and retreive the data

case when
field1 is not null then field1 else null end field1,
case when
field2 is not null then field2 else null end field2,
etc...

Hope it wont cause issues in the future.

 

Any idea why it is not working with 'CAST'?

Cheers!

 

Hi @Anonymous 

As searched, there may be several reasons as said in this document.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors