Forum Discussion

Bdickers's avatar
Bdickers
Frequent Visitor
2 years ago
Solved

Mashup Null Data to Non-nullable column Issue in Existing DataFlow Gen2

Like the subject says, I have an existing Gen2 Dataflow that has been working without issue for ~6 weeks and now without apparent reason is giving me an error regarding null data being inserted into ...
Dataflows
General Question
Need Help
  • miguel's avatar
    miguel
    2 years ago

    Depends on how you have your desktop version configured. For example:

    • Do you have the same privacy levels set in both environments?
    • Do you ignore privacy levels in desktop but not in dataflows?
    • Do you use any sort of function that requires access to local files, sources or systems that could be behaving incorrectly due to a network situation or scenario with the gateway?

    I'd highly encourage you to look into raising a support ticket so that an engineer can help troubleshoot the situation 

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Bdickers 

 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing here.

The error indicates that a mismatch of data types between your old mashup document and the new one.

There are a few possible reasons why you might be getting this error:

  • Thoroughly inspect the latest file in the SharePoint folder for potential data type changes in the relevant column. Look for inconsistencies or values with time components.
  • Ensure there are no null values in the Date column. Dataflow Gen2 doesn't support nulls in non-nullable columns.
  • If the source file's schema has changed, adapt your dataflow accordingly. Update data types or transformations to align with the new schema.

I hope this information helps. Please do let us know if you have any further questions.

Bdickers's avatar
Bdickers
Frequent Visitor
2 years ago

This exact source, and essentially same report, refreshes successfully in a PowerBI desktop file. If there was a null data issue, wouldn't this also be a problem in the desktop version?

I've rebuilt the source file for the dataflow and ensured there are no issues, it works in another version of the same dataflow and still getting the non-nullable error. 

  • miguel's avatar
    miguel
    Community Admin
    2 years ago

    Depends on how you have your desktop version configured. For example:

    • Do you have the same privacy levels set in both environments?
    • Do you ignore privacy levels in desktop but not in dataflows?
    • Do you use any sort of function that requires access to local files, sources or systems that could be behaving incorrectly due to a network situation or scenario with the gateway?

    I'd highly encourage you to look into raising a support ticket so that an engineer can help troubleshoot the situation 

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi Bdickers 

       

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
      Otherwise, will respond back with the more details and we will try to help.


      Thanks

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi Bdickers 

         

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
        If you have any question relating to the current thread, please do let us know and we will try out best to help you.
        In case if you have any other question on a different issue, we request you to open a new thread.


        Thanks