User Profile
Mikeblakeuk1
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Column names must contain UTF-8 encoded from blob inventory
Hello, f you set up blob inventory, you can't import the parquet into Fabric Lakehouses. In Azure Storage Setup Blob Inventory, with date fields. Wait 24 hours Download the parquet files In Fabric In a Lakehouse Upload the file Load to Tables, New Table Expected: It loads the data Actual: Error Server Error. Message : Invalid column name(s). Column names must contain UTF-8 encoded Unicode word characters and can be a maximum of 128 characters long. Unicode word characters include letters of any case and their nonspacing marks, punctuation connectors like the underscore(_), and decimal digits, but no space characters are allowed. Error Code : InvalidColumnName Error source : 1 Activity Id (Failed Request) : 4dc4de45-e218-4f94-9bd9-5ee067366b35 Client Session Id : 27e1b3bc-7e9c-4880-b764-7d527e6c042f Activity ID (Initial Request) : ec4a448e-5e47-447b-8198-4065850c7036 User session Id : f04a022f-c25c-4289-a42d-cd7f97a20cac Do we know what column is causing the issue? I assume - a) Can Microsoft Storage export with valid parquet column names? b) Can Microsoft Fabric import and handle column with bad chars. we don't really want a pipeline to process the file, fixing the column. it should just work Note, the preview appears to work.
