how can I link a dataset to all the tables in a database - using a SQL federated connection

tammy_evans
tammy_evans Member
in Datasets

If I have a valid federated connection - that I can browse all the tables - how do I link a dataset to all the tables? (I've done it once apparently - but now I can't figure out how to do it again)?

Every option I come up without only lets me select one table at time - and that can't be right… I've got o be doing something stupid and missing something simple….

Answers

  • tammy_evans
    tammy_evans Member

    Microsoft SQL Server by the way

  • tammy_evans
    tammy_evans Member

    Ugh - and I just realized these datasets are really only 1:1 tables or views - so can't really do what I'm asking . 🤯

  • tammy_evans
    tammy_evans Member

    Never mind - literally got it after I posted this. Apparently - I hadn't used the variable anywhere on a card….. althought it existed - and was used in a calculation - that calculation wasn't actually "used" in any visualization or filter or anything. Once I used it (which honestly was a mistake - not on perhaps) - the variable showed up to select on other card.

Categories