I'm trying to determine if there's a way to Join two queries from two different sources with the use of a where clause within PowerBI.
For example I have a query that imports data from Palantir Foundry and a query that imports from Teradata. There is a relationship between these two tables (Sales and Employee records) using the Employee_ID however, this is not sufficient since there are multiple months of data on both records. I need to use another field so that i can tie in the date of the sale to the Employee start/end data to ensure that i pull the current employee hierarchical data.
I need to avoid a many to many relationship for this data and the only way to do this on this data set is to use another field.
Can this be done in Power BI?
For example I have a query that imports data from Palantir Foundry and a query that imports from Teradata. There is a relationship between these two tables (Sales and Employee records) using the Employee_ID however, this is not sufficient since there are multiple months of data on both records. I need to use another field so that i can tie in the date of the sale to the Employee start/end data to ensure that i pull the current employee hierarchical data.
I need to avoid a many to many relationship for this data and the only way to do this on this data set is to use another field.
Can this be done in Power BI?
