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?

      • tringuyenminh92's avatar
        tringuyenminh92
        Memorable Member
        9 years ago

        Hi AndrewP,

         

        So far you could use import mode, but DQ and Import mode are different from refreshing schedule and another points. In my mind, i hope DQ could have this mixing source in future version of PBI.