Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm using date dim which is imported from SQL DB and joined to Table A(Join condition is Date column from Date Dim to Created Date in table A, both data types are same).
When I pull date doulmns from both into a report the date dolumn from date dim is getting blank as shwn in below screenshot.
Can anyone let me know how can I fix this issue.
Thanks,
Anand
More info please. Did you change the type in Power Query? Did you extract the date portion and use that as a column?
If you did it in Power Query, try a test by Merging the two tables with an Inner Join to see if they find matches
Respect to you because that is the correct way to test these things.
What is the datatype of the two fields? If it is datetime the time portion can cause the relationship to break.
Can you show some examples from Power Query screen please?
Initially the date type of these two fields are like datetime but later I have changed it to date in both tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |