Forum Discussion

Tom_CA's avatar
Tom_CA
Icon for Helper I rankHelper I
1 year ago

Database in Fabric - Datatype columns

Hey folks, I created a small pipeline to load data into the fabric database, and a tiny problem appeared. My Dataflow Gen2 loaded data correctly and created a table as required. However, when I use t...
workspaces
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Tom_CA 

 

Are you using the preview SQL database feature in Fabric? When you loaded the data through Dataflow Gen2, did you set the Id column as Int type or String type? 

 

Best Regards,
Jing
Community Support Team

Tom_CA's avatar
Tom_CA
Icon for Helper I rankHelper I
1 year ago

Hey Anonymous Thank you!

Yes. I created it using the preview SQL database feature in Fabric. When I load the data through Dataflow Gen2, it is int type as it was created. The table was created correctly, but the preview is wrong.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Tom_CA 

     

    I can reproduce this. When checking the column schema, the data type is correct as set. As you said, the table is correctly created. It might be an issue in the data preview of Explorer. 

    Please open a support ticket to Microsoft to highlight this issue directly. How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    Best Regards,
    Jing