Power Query Tips: SQL Script from Files (part 1)

In this video, I show you how to modify your query based on a SQL script. Normally, you would need to copy and paste the code any time you change the script. But with some M magic, we can point Power Query directly at the file.

[qasimjan]

Yes Sir, learned alllot and eager to learn more. Thanks

[marklovejoy]

Hello Juan, thank for the video. Would it be possible to remove columns before the import into the Power Query using an SQL Script? The source where I'm getting the data is really slow and there are lot of calculated columns that should be excluded from the import.