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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors