Database in Fabric - Datatype columns

[Tom_CA]

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 the data preview view, the data type columns available in my data preview are disconnected from what I have in my table, as you see below.

[v-jingzhan-msft]

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]

Hey @v-jingzhan-msft 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.

[v-jingzhan-msft]

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