Import data using dax in power bi from SSAS Tabular between 2 databases

[Anonymous]

Hello All,

I am facing issues while importing data using dax queries in power bi from SSAS tabular by using one specific column of one table in a database for filter or lookupvalue option, which will pull the data from another database.

Let's assume, we have x and y as databases.

• In x database we have one table named as Employee with a column as EmployeeID. 
• In y database we have a table named as Organization with a column as EmployeeID.

I want to import the data of Organization table from y database, only those who have matching data between Organization[EmployeeID] & Employee[EmployeeID](filters by the IDs present in Employee[EmployeeID]).

Need help in dax query!!!

[amitchandak]

@Anonymous , You have to filter that power query. merge and remove non matching rows. Or check if it allows you write DAX to select data in source

Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query