Forum Discussion
How to combine data from two different databases and keep the mode Direct query?
I've a problem where I'm asked to keep my model in direct query. I'm pulling data from MS SQL Server DB and Oracle SQL DB in DIRECT query mode. I need to combine the data pulled in direct query from...
anuragccsu Hi!
Use DAX to calculate a third combined table, like:
CombinedTable =
UNION(
SELECTCOLUMNS(MSSQLTable, "Column1", [Col1], "Column2", [Col2]),
SELECTCOLUMNS(OracleTable, "Column1", [ColA], "Column2", [ColB])
)
BBF
BeaBF thanks for response, however DAX also doens't help either!
I created the required columns using DAX and selected columns but no value in the combined union DAX table.