Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pistachio_
New Member

data fields get null in dataflow gen2 get data from Dataverse

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:

 

Pistachio__0-1718863865162.png

 

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

 

Pistachio__3-1718864055733.png

 

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

 

 

 

 

3 REPLIES 3
v-cboorla-msft
Community Support
Community Support

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.

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.

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

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.