Rows are lost between dataflows

[Anonymous]

Hello,

I have created two dataflows (A and B) with the folowing structure:

Data in Sharepoint -> Dataflow A -> Dataflow B

I have one column in Dataflow A which sum, right before going to be ingested by Dataflow B, is 103863.

When I go to Dataflow B, right after the ingestion, the sum of the same value is 89912.

When the flow A ends, the values is of the type Decimal number.

I also counted the values and apparently values are lost from the Dataflow A to Dataflow B.

I also tried to connect power BI Desktop to both dataflows and there both give the same value (the value from Dataflow B): 89912.

What could be wrong here? Is there any known issue in the connection between flows?

Adding images with the Count Rows.

Data Flow A

Dataflow B 

And when I connect both flows to power BI, instead of having as a sum the value 103863, I get the value from Dataflow B for both flows:

Recently notived also that the values in Data Flow B are different each time I refresh the data flow A. Can it be somehow related to admin configurations? 😕

Thanks for your help,

Pedro

[v-easonf-msft]

Hi , @Anonymous 

Not   clear what happened. I have not encountered a similar problem

Please  refer to this thread.

https://community.powerbi.com/t5/Power-Query/Data-lost-between-Power-Query-and-Power-BI/m-p/747666 

Is it caused by similar reasons?

Best Regards,
Community Support Team _ Eason

[Anonymous]

@v-easonf-msft , I just editted the post with some images, hope it is clear now.

It is not the issue you mentioned into that thread...

Thanks for your attention

[v-easonf-msft]

Hi , @Anonymous 

Sorry I can't fix it on my side currently, please kindly raise it to the support team t investigate this issue.Once you create a support ticket and get any workaround, please kindly share it here for reference. Thanks a lot.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.