Power BI - Power Query & M Training Course

AdvanceD Power Query

Merge and Append queries
Create a blank Query
Create a custom table
Enter data manually
Create a table using M coding
Conditional column
Multi-condition column
Columns from example

M

The M Syntax
M language reference table
M Query Basics
Variables and Parameters
Parametrize data source
Create M Query Functions
Invoke functions
Automate import using M function
Create date table using M

Power BI Administration

Data Refresh When, Who, What
Gateway : overview, installation, when needed
Which connection require a Gateway and which do not
Scheduling Data Refresh
Data refresh and licencing
Gateway: personal mode and Enterprise mode
Gateway: prerequisites
Gateway installation
Gateway Configuration
Gateway and direct query
What Gateway do
Security
Data at rest
Data in Use
Data in Transit
Security Users access
Implementing Row Level Security
Implementing Dynamic Security

Administration portal
Usage metrics
Users administration
Tenant settings
Embedded code
Manage custom visuals
Global administrator
Manage user licence
Manage Group and workspaces
Audit logs