Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
Hi Ritaf1983, thank you! It was that the problem!
Happy to help😊
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 ?
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
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |