In this video we are going to look at a brand-new app coming to Office 365 called Microsoft Lists.

This new app was announced by Microsoft at their online Build conference this week so I thought I'd have a look and try and understand what it is they are doing and give you my thoughts on it.

TEAMS TRAINING
If you like this video, and want to know more about Microsoft Teams, check out our Teams Champion online training course. https://bit.ly/2Uwh1p3

🎓 TRAINING
TEAMS CHAMPION: https://bit.ly/2Uwh1p3
SHAREPOINT CHAMPION: https://bit.ly/3bBXHMF

🤝 CONNECT WITH US:
NEWSLETTER: http://bit.ly/3cnh1P4
WEBSITE: https://www.collaboration.coach
SCHOOL: https://school.collaboration.coach

🎵 MUSIC: Happy Trails by Text Me Records/Jorge Hernandez

Как построить сводную таблицу на основе данных нескольких источников? Power Query предлагает на выбор шесть различных способов объединения. Разберемся, как они работают.

Download Google Ads (Google AdWords) connector for Power BI here: https://github.com/morinad/google_ads_pq/blob/master/GoogleAds/GoogleAds.mez

Replace USERNAME with your own: C:\Users\USERNAME\Documents\Power BI Desktop\Custom Connectors

Report type list:
https://developers.google.com/adwords/api/docs/appendix/reports/all-reports

Content:
0:19 - enable using custom connectors in Power BI,
0:34 - find the folder for our connector Power BI (.mez),
0:59 - use Google Ads Connector in Power BI,
1:07 - 5 parametres of Google Ads function,
1:56 - choose Google Ads account,
2:27 - change report type in Power Query,
2:41 - how to get Device statistics from Google Ads,
3:05 - Google Ads function description,
3:47 - get age range statistics to Power BI,
4:15 - unload report to Power BI Service,
4:33 - check Power BI personal gateway,
4:47 - edit Google Ads credentials in Power BI service,
4:59 - refresh Power BI dataset and scheduling refresh.

Another interesting videos:
Accessing table elements in Power Query: ht…