Forum Discussion

Mrizzo21's avatar
Mrizzo21
Frequent Visitor
1 year ago

Gen2 Dataflow Started Failing - Nullable Issue

First time positng to the Fabric Community, but this community has been a HUGE resouce for me in all my work, so thank you eveyone.  I have a dozen or so Gen2 Dataflows that pull from a SharePoint l...
Dataflow
Suzanne_Shuford's avatar
Suzanne_Shuford
Frequent Visitor
1 year ago

This is happening to me as well on a pull from a google sheet.  Not a database, yes it can be null.  Two different fields one was last name, the other was and order number for web orders.  So if it isn't a web order it would not have an order number.  I have tried changing the data type, trimming, cleaning replacing blanks...no luck. Why would a varchar not allow nulls?  or blanks.  This has never been an issue before.  Any help would be apprecated.  

error:  The 'Web Order Number ' column in 'Purchases' table is invalid. Column names must contain at least one alphanumeric character, and cannot begin or end with blank characters.

Suzanne

mcwires's avatar
mcwires
Frequent Visitor
1 year ago

Hello Suzanne. Bit of a guess here, but I'm wondering if your error is different. The error states, "end with blank characters". And you have quoted "Web Order Number " with a trailling space. Might it be worth checking that and removing if it is there?

Mike.

  • Suzanne_Shuford's avatar
    Suzanne_Shuford
    Frequent Visitor
    1 year ago

    I did not remove the field, but I did trim and clean it.  Since it was several fields and one being a name, I am still unclear, why you could not have a blank or null in a varchar field. These are not key field, from a google worksheet.