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...
rnola16's avatar
rnola16
Icon for Advocate II rankAdvocate II
1 year ago

Was trying to establish a join relationship between two tables without needing to do a customized SQL in direct query. The tables does have parameters on date and other cols. I do not need the million data points into my result but to query against the two tables.

 

sample query :

 

SELECT A.EMP_ID, B.NAME

FROM

A LEFT OUTER JOIN B ON A.ID = B.ID

WHERE

A.EMP_ID = 'Pamater1' and B.NAME = 'Parameter2' and B.Date >= 'Parameter3'

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).