Forum Discussion

laphroaig76's avatar
laphroaig76
Helper I
2 years ago
Solved

Error code -804 Firebird Database

Hi 

I loaded a Firebird Database via ODBC into Power Query and all worked fine.

Then I added in the table VERRECHNETELEISTUNG the custom column called Type... if [Tarifstufe] = 5872 then "internal" else "external" with the correct results.

--> Close and load to Desktop I get the following error message

Without the custom column it loads properly...

 

What is the reason for that message?

Thank you.

 

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    What is the reason for that message?

    Powr Query doesn't know how to handle the data type of your custom column. Use CAST or similar to make it into a Text column.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    What is the reason for that message?

    Powr Query doesn't know how to handle the data type of your custom column. Use CAST or similar to make it into a Text column.

  • laphroaig76's avatar
    laphroaig76
    Helper I
    2 years ago

    Ok, I have no clue what CAST is. I changed the format in Power Query to text with the same result.

    But I found a workaround. Thank you for your help!