Forum Discussion

laszloberzi's avatar
laszloberzi
New Member
4 years ago

Dataflow error: "Error: PipelineException"

Dear Community,

I got an error message when I would like to refresh my dataflow:

"Error: PipelineException: This query is too complicated to run. . Param1 = PipelineException: This query is too complicated to run. "

 

The blocked table / query has only one MERGE and one APPEND!

Nothing else, so it is not complicated my POV.

 

"

let
    Source = Table.Combine({SRC_Fuvarrend_Fej_alv, SRC_Fuvarrend_Fej_saját}),
    #"Merged queries" = Table.NestedJoin(Source, {"SZALLNEM"}, SRC_SzállításNem, {"KOD"}, "SRC_SzállításNem", JoinKind.LeftOuter),
    #"Expanded SRC_SzállításNem" = Table.ExpandTableColumn(#"Merged queries", "SRC_SzállításNem", {"MEGNEVEZES"}, {"SRC_SzállításNem.MEGNEVEZES"})
in
    #"Expanded SRC_SzállításNem"

"

 

What might be the problem?
Has anyone encountered a similar error?
I googled the error but couldn't find any relevant answers.


Thank You in Advance,
Laci

 

 

Dataflow
Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi laszloberzi ,

     

    //Error: PipelineException: This query is too complicated to run.

    Do these two tables have a lot of data?
    If so, try to streamline the tables by deleting the columns or rows you don't need and try again.

     

    You may split the above steps in the data flow, save and refresh to find out which steps may be problematic. You may also copy the same steps in the desktop and refresh to check if an error will be reported.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data