Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-ImportSQLIntoPowerQuery-Finished.xlsx
Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MPSTDA-PowerBIDesktop-GetSQL-Data.pbix
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-PowerQueryImportSQLData.pdf
In this Video discusses the new “View Native Query” feature in Power BI Desktop Power Query and Office 365 Excel Power Query to determine which of the Applied Steps are sent back to the SQL Server Database as part of Query Folding.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!