MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature!

Подписаться 1 млн

Просмотров 13 тыс.

50% 1

Download Excel FINISHED File: people.highline.edu/mgirvin/A...
Download Power BI Desktop FINISHED File: people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: people.highline.edu/mgirvin/A...
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 powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

Опубликовано:

11 сен 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@shoeshines2121 4 года назад

Thank you for explaining the Query Folding concept in the last video and referring back to it in this follow-up video. This is a great method to explicitly check if the data transformations are being sent back to the source database versus Power Query itself.

@GeertDelmulle 5 лет назад

That’s what I call: leaving no stone unturned.

@excelisfun 5 лет назад

The Power Query logo used in this video is copyright of and used with the express permission of

@chrism9037 5 лет назад

500K subs. Well-done Mike and well-deserved!

@GeertDelmulle 5 лет назад

Mike, You've done it! Yay!

@MalinaC 5 лет назад

Thanks for the video and CONGRATULATIONS on 500k subs!!!!

@ismailismaili0071 5 лет назад

thank you Mr. mike for the update

@filipsvakjaroski20 3 года назад

Thank you Mike :)

@mazarata73 5 лет назад

Thanks for the update.

@pmsocho 5 лет назад

Great tip!

@stevennye5075 4 года назад

Nice!

@orcawilly54 4 года назад

Thanks for the video, just what I needed. In my office I have a MS OFFICE 2016+ edition and the feature with the View Native query is not available there.

@abrilgonzalez7892

Thank you Sir for this Class! I absolutely aprecciate It

@NoShadowOfDoubt1 5 лет назад

That is great news ... but if they can make power query able to update the values in an SQL table ... that will be amazing

@hosseinhosseinpoor9561 2 года назад

good

@ramyth1946 Год назад

1. "In God we Trust. All others must bring data" Quote by W.Edwards Deming. 2. Data is not information, information is not knowledge, knowledge is not understanding, understanding is not wisdom. Quote by Clifford Stoll. So, if one wants to graduate to the wisdom state, one has to use microsoft's MSBI. Again, there is a famous indian sanskrit quote: अज्ञेभ्यो ग्रन्थिनः श्रेष्ठाः ग्रन्थिभ्यो धारिणो वराः ।