Forum Discussion

Angeal1702's avatar
Angeal1702
Regular Visitor
1 year ago
Solved

Dataflow Gen 2 Mashup

Hi, 

 

Having the below issue with one of my tables not refreshing and getting the error codes below;

I've looked everywhere and cannot find an answer to this. Also as you will see it's only 1 table which is coming up with an error. I've checked and all tables have the same settings as far as I can see.

 

  • It turned out the table is was attempting to write to has too many parquet files so it couldn't update. After sorting out the Parquet files the power query ran fine. 

5 Replies

  • Hi. Mashuperror usually means that there is a problem in power query. It might be finding an error that you can't see at the data preview. Make sure to check errors at the tables. You can "Keep rows with errors". For example, something like a changed of type date to a field that looks like "01/200/2024" can be preventing the refresh.

    Make sure to check it.

    I hope that helps,

  • v-prasare's avatar
    v-prasare
    Community Support

    Angeal1702 As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

    ibarrau, thanks for your promt repsonse

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • Angeal1702's avatar
    Angeal1702
    Regular Visitor

    It turned out the table is was attempting to write to has too many parquet files so it couldn't update. After sorting out the Parquet files the power query ran fine. 

    • v-prasare's avatar
      v-prasare
      Community Support

      Angeal1702,

      Hope your doing well.

       

      since you resolved your issue, please accept your post as solution as this will help other community members find similar answeres quickly.

       

       

      Thanks,

      Prashanth Are

      MS Fabric community support

  • v-prasare's avatar
    v-prasare
    Community Support

    Angeal1702 As we haven’t heard back from you, If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support