In order to make Direct query more useful it needs to support data from more than one source.
We are planning to adopt Power BI and this feature is an absolute must. But unfortunately this is not available. The equivalent feature seems to be available in Tableau 10. https://onlinehelp.tableau.com/current/pro/desktop/en-us/joining_tables.html
