Reply
DaroMelArg
New Member
Partially syndicated - Outbound

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

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.

DaroMelArg_2-1687550615348.png

This is the table in Power BI

 

DaroMelArg_3-1687550688321.png

 

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

 

Someone has a clue, what could be happening?

 

Thanks!

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Syndicated - Outbound

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
DaroMelArg
New Member

Syndicated - Outbound

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

Syndicated - Outbound

Happy to help😊

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Syndicated - Outbound

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 ?

Syndicated - Outbound

Hi @poojitha_B 

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Ritaf1983
Super User
Super User

Syndicated - Outbound

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)