Fabric Warehouse Internal Error: Parameter is not expected to be null or whitespace

[ShermanCAA]

When trying to refresh or to create new tables in Fabric Warehouse, error occurs with the following message: "An internal error happened due to failed runtime assertion: Parameter 'columnName' is not expected to be null or whitespace.."

Would anyone know the root cause of this error? No columns in the warehouse appear to be null or whitespace.

[v-nmadadi-msft]

Hi @ShermanCAA 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @ShermanCAA 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @ShermanCAA 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @ShermanCAA  ,
Thanks for reaching out to the Microsoft fabric community forum.

Please double check for any syntax errors when creating a new table and ensure that all data types used are supported.
Data Types in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn
Here is the list of unsupported data types in warehouse

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[BhaveshPatel]

Hi @ShermanCAA 

You can create a table in Dataflow Gen 2 and set default destination to Warehouse. Correct way 

or

Change columnName to Full instead of whitespace in DataWarehouse. Like FirstName instead of "First Name".