CUSTOMISED
Expert-led training for your team

Dismiss

Power BI - Power Query & M training course

Name: Power BI (Dax, Visualisation, Power Query, M)
Start: 2025-10-15 00:00
End: 2025-10-18 00:00
Location: Power BI - Power Query & M training course

Use Advanced functionality in Power Query to import files, cleanse data, create functions in M Language

“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work. The presenter was very helpful and had great knowledge of Power BI."

AG, Business Analyst, Power Query & M, January 2021

Watch live Client feedback - Python & Power BI training courses:

Public Courses

20/01/25 - 1 days

£795 +VAT

Enrol

03/03/25 - 1 days

£795 +VAT

Enrol

14/04/25 - 1 days

£795 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates Related Courses

Public Courses

Highlights

Acquire skills in advanced Power Query to merge, create and append queries
Explore advanced functionality in Power Query to import files, cleanse data & create functions in M Language
Learn to parametrize data sources to define parameters that you can use in various ways when working with your data
Use M language and explore M functions to create a table with M coding
Use Power BI Administration to Schedule Data and Refresh Data
Learn about licencing and Gateway
Understand how to administer security, tenants and permission
Acquire knowledge on how to implement and apply security

An exercise from DAX programming part of Power BI training course.

Course Details

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

Who should attend

Business Analysts, Financial Analysts, Data Scientists and Staff who already use Power BI or who have attended our introduction course and who need to explore its features in more depth. Developers and Super Users/ Power Users looking to get more out of Power BI.

Learn to build Dashboards like this mixing and matching different data sources and filter access through dynamic security - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...

Feedback

4.8 out of 5 average

AG, Business Analyst, Power Query & M, January 2021

Watch live Client feedback - Python & Power BI training courses:

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Top 20 "Pain Points" for Data Analysts

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox

More about this course

Our Power BI - Power Query and M training course for Microsoft Power BI is aimed at Power BI users who want to get even more out of this popular tool.

We will show you how to use Power BI to administer security, tenants and permission. You will also use advanced Power Query functionality to import files, cleanse data and create functions in M Language.