SOLVED: What is the most efficient way to get SQL data in PowerQuery?A.By running the query without headers.B.By first running the SQL query in a platform like Visual Studio,then saving the file, then uploading to Power Query is the mostefficient approach.C.It is not possible to get SQL data directly into Power Querywithout first doing a lot of work.D.Linking directly to an SQL database saves having to run query,save file, and then upload it to Power Query - instead done in onestep.

Data Preparation, Transformation & Cleaning with Power Query