Forum Discussion

rnola16's avatar
rnola16
Icon for Advocate II rankAdvocate II
1 year ago

NATURALINNERJOIN - Large Tables

Hi,   I got two large tables  in our database (Teradata)  each having 300 cols and 3 billion records. In PBI, using direct query I brought in 3 fields from each of the tables and created a relatio...
Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

It's still not clear why you are manually creating a query with a inner join. With a tabular model if you have a relationship defined you don't need to mention it in the DAX query, it's inherent 

rnola16's avatar
rnola16
Icon for Advocate II rankAdvocate II
1 year ago

Because under 'Manage Relationships' you only can define one-one/one-many etc but not the kind of join you want like ( left/inner).