Different values between a table in Power Query and the same table in Power BI

[DaroMelArg]

Hi!!

I have a table in Power Query that contains values, that don't appears in the corresponding table in Power BI.

It's very strange. There is no filter. I updated the values.

This is the table in Power Query, in the last step.

This is the table in Power BI

The date 1/5/2023 is in Power Query, but not in Power BI.

Someone has a clue, what could be happening?

Thanks!

[DaroMelArg]

Hi Ritaf1983, thank you! It was that the problem!

[Ritaf1983]

Happy to help😊

[poojitha_B]

I have two tables in my data Table 1 and Table 2. I joined them with one to one relationship with a common column called ID. But when I try to find profit for all the id's in table 1 then its showing wrong values why ?

[Ritaf1983]

Hi @poojitha_B 

I saw your post , need some data to work with 🙂

[Ritaf1983 · Accepted solution]

Hi @DaroMelArg 

Does the data source include this date?

It seems not...

Once you have clicked "close and apply"

Since the data source is in the process of being refreshed, if the date does not exist in the data source, it will not appear.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly