How to access global environment objects in Power Query

  Рет қаралды 1,122

Exceed Learning

Exceed Learning

Күн бұрын

In this short video, we will explain what is the shared keyword in Power Query and how to use it to access the global environment of the current file.
The global environment contains all the objects that are available in the current Excel/Power BI file.
The keyword shared can also be used as an M function library.
For more on Power Query, check out our Power Query course!
exceed.hr/en/a...
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер
On-premise incremental refresh with Power BI Pro Dataflows
13:57
Exceed Learning
Рет қаралды 17 М.
Dynamic Coalesce in Power Query ( Record.SelectFields() )
9:42
Exceed Learning
Рет қаралды 3 М.
He bought this so I can drive too🥹😭 #tiktok #elsarca
00:22
Elsa Arca
Рет қаралды 44 МЛН
МЕБЕЛЬ ВЫДАСТ СОТРУДНИКАМ ПОЛИЦИИ ТАБЕЛЬНУЮ МЕБЕЛЬ
00:20
The FASTEST way to PASS SNACKS! #shorts #mingweirocks
00:36
mingweirocks
Рет қаралды 13 МЛН
У ГОРДЕЯ ПОЖАР в ОФИСЕ!
01:01
Дима Гордей
Рет қаралды 6 МЛН
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
How to process multiple folders with a single Power Query script
13:17
Exceed Learning
Рет қаралды 13 М.
Stop Doing Manual Reconciliations in Excel: Use Power Query
16:18
Excel University
Рет қаралды 76 М.
How to fix Incorrect Totals in Power BI
14:44
Goodly
Рет қаралды 50 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Reverse fill down (Unfill) in Power Query
9:46
Exceed Learning
Рет қаралды 2,5 М.
How to use Microsoft Power Query
16:35
Kevin Stratvert
Рет қаралды 1,9 МЛН
He bought this so I can drive too🥹😭 #tiktok #elsarca
00:22
Elsa Arca
Рет қаралды 44 МЛН