Forum Discussion

Wasabiii's avatar
Wasabiii
Frequent Visitor
2 years ago
Solved

Can't append in a Dataflow | No errors indicated in the Dataflow's Status report

Hi everyone,

 

I wanted to append queries in my Dataflow in order to have a table with all the data, so far, logical.

Below is another screenshot of my final table : 

When I load all tables and don't append, it saves and refreshes normally. But if I do not accept the loading of the tables to append them into a single table and I load this one as above, then it saves but throws an error after 30 seconds, with an empty error message !

 

 

 

FYI, each table is exactly identical in architecture, with these 5 columns, the same type on each table etc.

 

I don't know what else to do since I know that the problem comes from the 'append queries' but I doubt it's a bug or a technical impossibility... any idea?

 

Thanks for your feedback !

  • Wasabiii's avatar
    Wasabiii
    2 years ago

    Hi SaiTejaTalasila thank your for your feedback ! 

     

    Here is the solution that worked for me, found in the post you indicated :

    • Open the dataflow
    • Go to Home > Options
    • Go to Privacy and check "Allow combining data from multiple sources".

    Thanks again, I couldn't find any solutions despite my research!

2 Replies

  • Hi,

     

    Is your workspace premium?

    Please check this -https://community.fabric.microsoft.com/t5/Service/Dataflow-refresh-failure-when-appending-pro-capacity/td-p/3295124

    • Wasabiii's avatar
      Wasabiii
      Frequent Visitor

      Hi SaiTejaTalasila thank your for your feedback ! 

       

      Here is the solution that worked for me, found in the post you indicated :

      • Open the dataflow
      • Go to Home > Options
      • Go to Privacy and check "Allow combining data from multiple sources".

      Thanks again, I couldn't find any solutions despite my research!