Forum Discussion

ramiromejia's avatar
ramiromejia
Frequent Visitor
2 years ago
Solved

Addressing Data Lake Refresh Issues Caused by Mashup Document Errors

Hi,

I'm reaching out regarding a recurring issue I've encountered while attempting to refresh a table in my data lake. Every time I make modifications to the table, I encounter an error related to the mashup document, hindering the data refresh process.

 

I've explored various approaches to resolve this issue, including following the community tips posted here: https://community.fabric.microsoft.com/t5/Dataflows/Couldn-t-refresh-the-entity-because-of-an-issue-with-the-mashup/m-p/3506887.

 

 

Despite trying suggestions like publishing later and disabling staging, the problem persists.

 

I'm reaching out to see if anyone has encountered this issue and overcome it. Are there any alternative approaches or solutions that have proven effective in resolving mashup document-related refresh errors?

thanks,

 

Dataflows
Tips and Tricks
  • ramiromejia's avatar
    ramiromejia
    2 years ago

    Hi, thanks for the response. I've resolved the issue. Even though PowerQuery didn't show errors, a NULL value existed in my table instances, causing an error during the data lake loading.

    Do you know if there is a debugging method similar to the one Data Factory has?  It's tricky to spot such errors in the code, especially with Power Query M.

3 Replies

  • miguel's avatar
    miguel
    Community Admin
    2 years ago

    Hi!

     

    This might require a deeper investigation by our team to determine what could be causing the issue with your Dataflow Gen2.

    Please reach out to our support team so they can create a case number. You can share it with us and we can share it with the product group as well. Below is the link to reach the support team:

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

    • ramiromejia's avatar
      ramiromejia
      Frequent Visitor
      2 years ago

      Hi, thanks for the response. I've resolved the issue. Even though PowerQuery didn't show errors, a NULL value existed in my table instances, causing an error during the data lake loading.

      Do you know if there is a debugging method similar to the one Data Factory has?  It's tricky to spot such errors in the code, especially with Power Query M.

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

        Hi ramiromejia 

         

        Thanks for using Microsoft Fabric Community.

        Glad that you query got resolved and thank you for sharing the same with the community as it can be helpful to others. 

        Please continue using Fabric Community for further queries.

         

        Thanks.