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
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. 

      • AndrewP's avatar
        AndrewP
        Helper I
        9 years ago

        Again, if we ignore the direct query aspect of my original question, how could I just include an additional table while using the same source?  For example, I set up the initial source and choose 2/10 tables, but I want to use 4/10 tables.  How would I select the additional 2 tables without creating a second source?