In order to make Direct query more useful it needs to support data from more than one source.
I have a Azure SQL database with lots of data that I am using successfully with PowerBI and direct query. This database has customer numbers but not names. I have a different database that has the customer list and I want to use the names to display but as soon as I try to add this second (small) database it says it needs to import the data from the first database. This is not possible as it is too big. My queries will be mostly against the one datasource but I need to use a "dictionary" type table from a different datasource to add more information to the report result.
