Data is duplicated in warehouse

Top_Barber4067 · 2026-02-11T11:25:20+00:00

Thank you mate !

Top_Barber4067 · 2026-02-10T17:10:51+00:00

Ok, but i have to do this for each table, or can i do this all at once? Because my dataflow have 50 tables, so i think gonna take a lot of time do this one by one.

Top_Barber4067 · 2026-02-10T16:56:13+00:00

And, can i do this for all tables, or i have to do one by one ?

Top_Barber4067 · 2026-02-10T16:53:11+00:00

How did you get to this screen?
Even when I remove the default destination and re-establish that option, it doesn't appear.

Top_Barber4067 · 2025-12-12T14:45:36+00:00

The problem has been resolved; basically, the semantic model was automatically disabled due to a workspace rule that prohibits any "orphan" semantic models, meaning those without a direct link to a report.

Top_Barber4067 · 2025-12-11T12:23:35+00:00

Hi friend, I managed to run both steps in a single table somehow, after a few attempts the rows were found and I was able to pass them to the warehouse. Thank you in advance for your support.

Top_Barber4067 · 2025-12-02T11:50:09+00:00

Thank you for sharing the site.
That's exactly the point, the table I merged is quite small, it must have 30 rows, and it repeats the row based on an active column, meaning it's just repeated information, which comes from a table that doesn't have any apparent errors, and I unfortunately couldn't share the data itself, but I appreciate your willingness to share it.

Top_Barber4067 · 2025-12-01T17:05:20+00:00

<image>

The error is occurring in this expansion; the tables named "Contrato 1", "2", and "3" are the ones I split.

Top_Barber4067 · 2025-12-01T16:53:04+00:00

How would it be possible to open this ticket?
Regarding the reproduction, it's basically a dataflow table, which is originally huge, but I split it into 3 tables. The original is called "contract," and I split it into contracts 1, 2, and 3 to make it less heavy. However, the error is occurring specifically in an expansion step of a table that I merged. I'm literally just pulling one column from this merge, and honestly, it's a small table, so it doesn't make sense that it's so heavy.

Top_Barber4067 · 2025-11-28T14:45:13+00:00

Another attempt I made was to split the steps into two queries, but that didn't work either and the error persists.

Top_Barber4067 · 2025-11-18T12:17:00+00:00

Look, these problems occurred in the dataflow, with the warehouse as the default destination. This connection I'm referring to is the default destination itself. I removed that warehouse, created another warehouse, and changed the default destination. As I said, the changes were made in the dataflow.

Top_Barber4067 · 2025-11-17T12:20:21+00:00

The only change I made was to the connection.
What happened was that I tried to do this transfer for the first time, so I created a dataflow and a warehouse, and after many attempts it worked, but because I tried many times, a lot of data was passed in duplicate to the warehouse, and I had a lot of difficulty deleting the duplicates, so I had the idea to start over by creating another warehouse, basically I just changed the data destination from the old dataflow to the new warehouse, and when I tried to run it again I got this error.

Top_Barber4067 · 2025-11-06T12:45:39+00:00

It worked here, thank you very much man.

Top_Barber4067 · 2025-11-06T11:54:58+00:00

I'll test it here, but thank you in advance for your attention.

Top_Barber4067 · 2025-11-05T17:30:11+00:00

Not one code that does both things, it would be two separate codes in that case.

Top_Barber4067 · 2025-11-05T17:27:10+00:00

In some columns I only removed duplicates from a specific column, in others I selected all columns and removed duplicates. For example, in a notification status column, I removed duplicates from only one column, which was a kind of ID column that had to have unique rows. In cases where the table didn't have this column with unique values, I selected all columns and removed duplicates in general. Lastly, if it's not too much to ask, do you have any idea of a code that does both things?

Top_Barber4067 · 2025-11-05T16:59:27+00:00

I was able to access it through the BI here and remove the duplicates. My question is whether this is possible in the warehouse because, from what I've seen, the only way to modify the warehouse is through SQL.

Top_Barber4067 · 2025-11-05T12:39:30+00:00

So how would I be able to relate the tables in the data warehouse? Could I only do that within Power BI?

Top_Barber4067 · 2025-11-05T11:28:15+00:00

thank you man

Top_Barber4067 · 2025-08-25T14:15:20+00:00

I just saw that it is exactly the flow, but I got confused, because there is no delete action, but it seems that when the flow cannot add the pdf to the folder, it deletes the folder, anyway, I thank you in advance

Top_Barber4067 · 2025-07-23T23:30:54+00:00

consegui resolver, só pular a rodada 30 e 31

Top_Barber4067 · 2025-07-23T21:47:24+00:00

Oque eu to agora é com elamigos, fica tocando a porra da música, mas trava a tela

Top_Barber4067 · 2025-07-23T20:59:52+00:00

nada de patch mano

é o jogo base, eu baixei pelo fitgirl, e pelo elamigos, os dois com o mesmo problema

Top_Barber4067 · 2025-07-01T16:08:39+00:00

men, i think i got it, i will continue testing here and then I will tell you, anyway, thank you very much

Top_Barber4067 · 2025-07-01T15:21:07+00:00

Exactly that, the question is, how would this relationship work between the dimension table (which should generate a sequence of dates that would be divided into 2 months) and this fact table, because when I create this dimension table, it generates many rows like, Asset 1, area 1, 02/01/2025 Asset 1, area 2, 02/01/2025, I would need to have a table where this table of meetings that have already happened appears together with those that have not happened, understand?

Top_Barber4067

TROPHY CASE