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

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?

    • tringuyenminh92's avatar
      tringuyenminh92
      Memorable Member
      9 years ago

      Hi AndrewP,

       

       

      With Import mode, when you choose n-tables and refresh, PBI will generate separate n-queries to your source as SQL queries. So when you want to add 2 more tables after added 2 tables, you just choose get data/recent sources and select 2 additional tables. Is this your concern?

      • AndrewP's avatar
        AndrewP
        Helper I
        9 years ago

        No.

         

        When I started I created a new database source and selected specific tables.

         

        I would like to modify that to include more tables.

         

        How can I do that, and ONLY that?

         

        (Recent sources is empty)