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 Language

• 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

 (Cont...)

• 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 log