Forum Discussion
Using external data in a composite model and using imported data into measures
Hi all, I have recently switched to a DirectQuery model within my organization and am trying to use it using also custom data (from an excel file), thus creating a mixed (or composite) model. ...
BrendanCarron , related should work - https://youtu.be/aA4ROG9dg8A
The import model is best. In case of direct query, your source should take care of the need of lookupvalue and related. create a model that does not need a new column