Most RecentMost ViewedMost LikesUse cases for the multiple ways to "get data" Hi all, I was wondering if someone can clarify when to use these methods of loading data from SQL Server in Excel 2016 (maybe there is no difference) For example, I can use one of these three methods: 1. Get Data->From Database (Get and Transform Data) 2. Get External Data->From Other Sources->From SQL Server 3. Manage Data Model->From Database->From SQL Server When is using "Manage Data Model" a better choice (or not) than the other two options? thank you! SolvedGet & Transform: how to Load into excel not in table format Get & Transform is an amazing feature in new Excel version, but I am not able to figure it out neither find information online into how to get the result of the transformation in NOT tabular format as in the legacy version.
