Forum Discussion
Include additional table or query result using existing DB source
I have a setup in which I want to add another DB table query, and a direct SQL query result query.
I would like to reuse the existing source. I can't see any way to do that, so I'm pretty sure I'm missing something.
Can anyone assist with how to do that?
12 Replies
Hi AndrewP,
It is not possible to do it currently, because there is a limitation to using DirectQuery that all tables must come from a single database. See Limitations of DirectQuery.:smileyhappy:
Regards
What about just in general?
For example a MySQL source.
Then later I want to grab an additional table, how would I use the existing source for that?
Hi AndrewP,
If you have multiple sources and still want using Direct Query, you have build up datwarehouse to gather everything and pre-processing in there and PBI will access it directly.
