Forum Discussion
Advocate IINATURALINNERJOIN - Large Tables
Super UserPowerBI has two engines to answer queries, the Formula Engine and Storage Engine. With Import mode the storage engine is Vertipaq. The Vertipaq engine has a limited operation set, and the formula engine is more extensive. The formula engine will request a data cache from the storage engine. The storage engine will perform as much data processing as possible and pass the results to the formula engine, which can perform additional more complex processing.
In DirectQuery mode the Formula engine issues queries to the remote datasource, in this case Terradata. You want to write your DAX to ensure as much processing occurs in the remote datasource is possible, and return data cache below the 1 million row limit. Since the query will be trying to satify a visual, 1 million rows should sufficent, as you will not be showing or plotting that many data points.
Without more info on what you are trying to do with that innerjoin is it hard to offer any help.
Advocate IIWas 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
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