1 Reply Latest reply on Apr 2, 2018 12:05 PM by Fred Jaworski

    General Efficiency Question: Create new data source vs add additional join?

    Ben Perlman

      I have a sql server connected to a spreadsheet that is used in 10+ dashboards (everything runs on extracts, nothing live).  In a new dashboard, I have an additional spreadsheet joined in.  I'm wondering what would be more efficient- either adding the join to the original connection that is used by the other dashboards, or keeping this as a separate data source, which means the workbook has an additional data source. Is it more efficient to minimize the number of datasources that a worksheet uses (in which case I will add the additional columns to the connection), or since the one spreadsheet is only used in one dashboard, keep that connection completely separate and only use it for the dashboard it is needed for?