Forum Discussion

GediminasC's avatar
GediminasC
Frequent Visitor
2 years ago
Solved

Error PipelineException: The argument value isn't valid

Hi, 

I have few working dataflows, but in one i keep getting error : "PipelineException: The argument value isn't valid" and it can not be refreshed on schedule. The purpose of this dataflow is to transform some tables.  The error comes from one the Computed entities. These are the applied steps in the entity: 

Refreshing data from power query does not give any errors. Linkded entities gives no errors and can be refreshed. Going through every applied steps does not give any errors, so what can be the problem? 

  • I dont see why merging should be a problem, wondering why.
    On another hand, i managed to solve this problem. It seems in one of the applied steps, Expanded table, collumn type wasnt determined it - it was the error. Repplied the step and it seems working now

2 Replies

  • The number of merges in a dataflow should ideally be zero.  You're pretty far off.  See if you can eliminate at least some of them.

  • GediminasC's avatar
    GediminasC
    Frequent Visitor

    I dont see why merging should be a problem, wondering why.
    On another hand, i managed to solve this problem. It seems in one of the applied steps, Expanded table, collumn type wasnt determined it - it was the error. Repplied the step and it seems working now