IMHO, better to use Get & Transform to query SQL server. You may use SQL query and/or transform data using Power Query, load result to data model and add measures and relationships with other sources if necessary.
Loading directly from Data Model is less flexible, option 2) looks like outdated.
Best Response confirmed by
EMCF Portal (New Contributor)
Thank you for the response - very helpful. It looks to me like there are redundant methods of acquiring data, but it's not really clear which method is the best for each use case. Perhaps the outdated methods are retained if users are familiar with them, but in this case I wasn't clear which method aligned best with SQL Server, and your answer cleared that up for me!