Forum Discussion

AndrewP's avatar
AndrewP
Helper I
9 years ago

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...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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

  • AndrewP's avatar
    AndrewP
    Helper I
    9 years ago

    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?

    • tringuyenminh92's avatar
      tringuyenminh92
      Memorable Member
      9 years ago

      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.

      • AndrewP's avatar
        AndrewP
        Helper I
        9 years ago

        If we ignore the direct query part of the question, how can I reuse a source to just pull an additional table as is?