Forum Discussion
Import data using dax in power bi from SSAS Tabular between 2 databases
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!!!
1 Reply
- amitchandak
Super User
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
