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

      • 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?