Forum Discussion

Suraj_1331's avatar
Suraj_1331
New Member
2 years ago
Solved

Getting error while refreshing Dataflow Gen2

I am using MS fabric for one of my customer. My source is On-Prem sql and sink is my warehouse within fabric, I am trying to fetch 6 tables using dataflow gen 2. Once Dataflow Gen2 got refresh, it re...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Suraj_1331 ,

    The error message indicates an issue with the application of an operator to incompatible types (Number and Record), which suggests there might be a problem in the way certain expressions or transformations are defined within your dataflow.

     

    Please check the steps:

    Examine the transformations applied in your dataflow, especially focusing on any expressions that use the operator . This operator is typically used for string concatenation or bitwise operations, so ensure it's being used correctly in the context of your data types

    Ensure that the data types of the columns involved in the transformations are compatible with the operations being performed.

     

    I have also found a similar post, please refer to it to see if it helps you.

    Solved: Re: Couldn't refresh the entity because of an issu... - Microsoft Fabric Community

    What i do now is after updating Dataflow Gen2,

    - i don't click click the Publish button right away,

    - I click other tables first,

    - close the Dataflow Gen2 to see the workspace again

    - find the updated Dataflow Gen2

    - wait for few minutes(1-5) because MS Fabric is slow in everything, i dont know if this is because im using Free Trial

    - after waiting for few minutes, near the name of my dataflow gen 2 iclick the "Refresh now" button, the one that looks like circle

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.