cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mariah-pg
Regular Visitor

Date Relationship Sometimes Working

Hello, I have a date table. (see image 1) I have 4 other tables and 4 corresponding relationships to the date table's "date" column. 2 of the relationships work, but 2 of them do not. All of the columns across the 5 tables have 'date' as their datatype. The structure of the date columns is YYYY-MM-DD. In Image 2, you can see that the table at the bottom is correctly showing the relationship with the date table. At the top of Image 2, you can see that data_date (from a different table) is not correctly joining with date from the date table. Image 3 shows the data type of affidavit_date from table 1, Image 4 shows how that affidavit_date column appears in SQL Server (this one is correctly showing the relationship). Image 5 shows the data type of data_date and Image 6 shows how that column appears in SQL Server (data_date and date do not correctly show their relationship).

 

The date table goes through mid 2022, so dates in the date table shouldn't be an issue.

 

Please let me know if any additional information would be helpful.

 

Image 1

2021-10-22_20h08_33.png

 

Image 2

2021-10-22_20h13_11.png

 

 

Image 3

2021-10-22_20h23_17.png

 

Image 4

2021-10-22_20h08_56.png

 

 

Image 5

2021-10-22_20h24_21.png

 

Image 6

2021-10-22_20h26_38.png

 

2 REPLIES 2
mwegener
Super User
Super User

Hi @mariah-pg ,

 

can you post a screenshot of the relationships in the model view?

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Hi @mwegener , Sure!

 

I'm not sure why, but I reloaded one of the tables (Table 2) that wasn't working and now it's working. 

 

In the image, the pink box is the date table. Tables 1,2,4,5, and 6 (all except table 3) connect properly. I can try to reload the data in table 3 and see if the issue gets fixed.

 

2021-10-23_12h50_08.png

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.