"Can't create relationship between two columns with incompatible data types"?

[littlemojopuppy]

Hi -

This is...odd.  Relationship between my date table and another is producing an error "Can't create relationship between two columns with incompatible data types".  Seems like a straightforward solution: fix the data types so they match...

But...after looking at both sides of the relationship, they do match (both are integer)

Has anyone ever encountered this before???

Both tables are based off views.  One (Dim_Date) is simply pull data from the source with no transformation at all.  The second view involves some manipulation of the underlying data to transform the data from the source.  Specifically:

1. Underlying data is a text date field in the format of YYYY-MM
2. Concatenate
   • LEFT() four characters for the year,
   • Then RIGHT() two characters for month
   • Then "01" for the day.
3. Convert that result into an integer data type.

These transformations are done in the view, not in Power Query.  Only thing I can think of is that the data that comes into the tabular model isn't valid and is causing errors.  But I've reviewed output from the views and data coming into model, and everything seems ok.

Anyone ever encounter something like this before?

[littlemojopuppy]

Community Admins - 

This actually isn't solved.  The above post was nothing more than testing/proving that the two fields in question are the same data type.  Maybe this is a bug in Tabular Editor?  Who knows?  But it's definitely not solved.

If there's a closed / not solved status, feel free to change it to that...

[littlemojopuppy]

As a test, pulled the two views into a brand new pbix file.  Relationship created with no issues...