Power BI for Developer Course

Content Ideas
1

I want to suggest creating a course based on what Power BI Developer in the real world is doing.

Sample courses would be as follows:

Designing advanced queries using M

  • Understanding Query Design and the ETL Process
  • Introduction to Programming with M
  • Understanding Query Folding
  • Designing with Query Functions
  • Designing with Query Parameters
  • Creating Reusable Project Template Files

Developing custom connectors

  • Understanding the Role of Custom Data Connectors
  • Developing with the Power Query SDK
  • Packaging, Deploying and Testing a Custom Data Connector
  • Configuring Authentication for a Custom Data Connector
  • Understanding Authentication Flows with OAuth2
  • Creating a Custom Data Connector for the Microsoft Graph API

Power BI Service API

  • Power BI Service API Overview
  • Registering Applications with Azure AD
  • Programming Authentication and Managing Access Tokens
  • Developing Custom Applications to Publish PBIX Project Files
  • Patching Data source Credentials and Refreshing Datasets

Developing Power BI embedded

  • Overview of the Embedding Features in Power BI
  • Understanding Premium Capacities versus Embedded Capacities
  • Retrieving Embedding Data using the Power BI Service API
  • Generating and Managing Embed Tokens
  • Using the Power BI JavaScript API to Embed Reports and Dashboards
  • Writing Client-side Code to Interact with an Embedded Report

Securing Datasets using RLS

  • Understanding Row Level Security (RLS)
  • Implementing RLS in a Power BI Desktop Project
  • Designing for RLS with the User-Owns-Data Model
  • Implementing RLS Dynamically using the USERNAME Function
  • Designing for RLS with the App-Owns-Data Model
  • Generating Embed Tokens Restricted by RLS Roles
3 Likes
2

Thanks for the suggestions @ronald_balza! @BrianJ might want to review this.

1 Like
3

@ronald_balza ,

Thanks a ton for your detailed and thoughtful suggestions - always greatly appreciated.

We are very much on the same page on these topics. Personally, I think this is too weighty for a single course of reasonable length. Thus, we are dividing these up in the following ways:

  1. I have been having discussions with one of the top experts in the world on the use of APIs within Power BI. We are planning to meet next week to discuss formalizing plans for him to create a course series on APIs - the first one on using API within Power BI, and the second one on creating Custom Connectors.

  2. Power BI Embedded - this has been on my wish list for a while. It turns out that our very own @MudassirAli is expert in this topic and has agreed to produce a course on it later this year.

  3. Datasets and RLS - MS MVP Greg Deckler is just finishing up his fourth (!) Power BI book and after that has agreed to produce a course for us on maximizing the use of the Service in Power BI. These are definitely topics that would be covered in this course.

  4. Advanced M Queries - Some of these topics have already been addressed in @Melissa’s course content (and forthcoming course later this year). Of the topics that haven’t, I would be glad to talk with her about how best to address those content-wise.

I hope that’s helpful Happy to discuss further.

Thanks again!

  • Brian
3 Likes
4

Really appreciated @BrianJ for your response and for considering my humble suggestion. This will be beneficial for analysts that wanted to upgrade their skills in Power BI.

Once again, thank you very much!

Cheers,
Ronald

1 Like