data fields get null in dataflow gen2 get data from Dataverse

[Pistachio_]

Hi folks, i was trying to retreve data from the dataverse and after i pick the tables, some of the boolean fields displays values as null rather than 0/1, and i tried with other tables and the problem persists. 

My table in dataverse is called Timesheet, and have two boolean fields (yes/no with value 0/1) like below:

And here is what i got after SQL query in data factory, they all displays null which is wrong:

Can anyone help me with it? Many thanks in advance.

[v-cboorla-msft]

Hi @Pistachio_ 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[v-cboorla-msft]

Hi @Pistachio_ 

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.

[Pistachio_]

hi thank you for your follow up. the track numer is: TrackingID#2406270060002402