Forum Discussion

AndrewP's avatar
AndrewP
Icon for Helper I rankHelper 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'm missing something.

 

Can anyone assist with how to do that?

Need Help

12 Replies

    • AndrewP's avatar
      AndrewP
      Icon for Helper I rankHelper 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
        Icon for Memorable Member rankMemorable 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.