Forum Discussion

unclejemima's avatar
unclejemima
Post Patron
7 years ago

Character field vs Boolean field

I've got our Power BI tied into a Pervasive DB.   One of the columns in the table is showing blank values.  I contacted the dev. of the application what posts to the DB and asked them why its blank...
Need Help
HotChilli's avatar
HotChilli
Community Champion
7 years ago

What he's saying is, the field is character data type in their db but they only store one of two values there, for example, "Y" or "N".

I have no experience with pervasive db and powerbi but i think powerbi should be able to handle it.  I think you need to see what's happening in the Power Query editor because I see that other fields have Y/N data pulled through succesfully.

 

..and also, I think the field is a "soft delete" flag, which may mean if there's nothing there, it's an active record.  If there is a value in there, the record has been "deleted"

  • unclejemima's avatar
    unclejemima
    Post Patron
    7 years ago

    Yea, I'm fairly certain there is nothing there. 

     

    In 19,000+ records in that table, there is not one single value in the MarkDeleted column, and I know in the inventory control software there is hundreds.

     

    I went into the query and set the type from "TEXT" to "True/False" and i only get an error for all the records.

     

    I'm kinda stumped.