Forum Discussion

mmace1's avatar
mmace1
Impactful Individual
3 years ago
Solved

Bring in new table using existing Direct Query Connection?

Live Connection to Dataset A, that I switched to Direct Query, so that I could do a Composite Model. 

Now I've added a new table to Dataset A, and want to bring that new table into my report. 

I don't see how to include the new table in my existing Direct Query Connection to Dataset A - am I missing a place in the UI?  


 

  • Got it. 

    Go to Transform data

     

     

    >Data source settings
    > Select the direct connection you want more tables in

    > Click Change Source

    > Choose the same dataset you're already connected to

    > Click Create, then one can select additional tables in the popup.

1 Reply

  • mmace1's avatar
    mmace1
    Impactful Individual

    Got it. 

    Go to Transform data

     

     

    >Data source settings
    > Select the direct connection you want more tables in

    > Click Change Source

    > Choose the same dataset you're already connected to

    > Click Create, then one can select additional tables in the popup.