1 Reply Latest reply on Sep 11, 2013 7:55 AM by Matt Lutton

    Blended data and "Add to Saved Data Sources"

    Thai Huynh

      I have multiple data sources used in my visual. Each one is from table on same SQL database.


      Is it possible to save all these blended data sources in a TDS file using "Add to Saved Data Sources..." so relationships are retained.?


      Currently, I can save each data source to its own TDS file. To use them again, I open each one up again and the sources are available but relationships are not retained.


      Thank you!

        • 1. Re: Blended data and "Add to Saved Data Sources"
          Matt Lutton

          I don't believe so.  But you can set up all your data sources, and save/publish the blank workbook and use it to start a new workbook with the same setup. There may be other options, but unless Tables are joined together, they are treated as individual data sources.  Perhaps joining the tables into one source is what you really want?  Hard to say without knowing the data.

          2 of 2 people found this helpful