Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Wasabiii
Frequent Visitor

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.

Wasabiii_0-1716212164455.png

Below is another screenshot of my final table : 

Wasabiii_1-1716212242415.png

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 !

Wasabiii_5-1716212938333.png

 

Wasabiii_4-1716212729724.png

 

 

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

Wasabiii_2-1716212496507.png

 

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 !

1 ACCEPTED SOLUTION

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!

View solution in original post

2 REPLIES 2
SaiTejaTalasila
Post Prodigy
Post Prodigy

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

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!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors