- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi Ritaf1983, thank you! It was that the problem!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Happy to help😊
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @poojitha_B
I saw your post , need some data to work with 🙂
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-30-2024 12:42 AM | |||
01-20-2024 06:58 PM | |||
06-06-2024 07:43 PM | |||
08-02-2024 11:49 AM | |||
05-10-2023 12:20 PM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |