get and transform data
2 TopicsGet & 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.861Views0likes1CommentUse 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!Solved1.5KViews0likes2Comments