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

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

    Microsoft SQL Server by the way

  • tammy_evans
    tammy_evans Member
    Options

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

Categories