Forum Discussion
Important Concepts of DirectQuery
Before opting to go with a DirectQuery connection, it is important to get a better understanding of it. • Better scalability since extremely large datasets can be used for building reports and the...
edhans
Community Champion
Community ChampionI've created direct query models across data in different databases. You have to create views in a single database pointing to the other databases, then connect to those views.
There are some limitations with visuals too in Direct Query.
Good writeup!