TedPattison
Microsoft Employee
‎02-20-2023 10:25 AM

Learn to Develop an External Tool for Power BI Desktop

This month's Power BI Dev Camp session examines how to automate tedious data modeling tasks in Power BI Desktop by developing an external tool using C#, the Tabular Object Model (TOM) and Visual Studio 2022. Campers will learn how to build a custom .NET application that connects to datasets running locally in Power BI Desktop. The session also teaches campers how to program with TOM to create and modify datasets objects such as tables, columns, measures hierarchies and RLS roles. Along the way, campers will learn how write code which executes DAX queries, creates calendar tables and formats DAX expressions.

What Campers Will Learn:

  • Deploy a Custom .NET Application as External Tool for Power BI Desktop
  • Export a dataset definition as model.bim file
  • Automate the creation of tables, columns, measures and hierarchies
  • Automate the creation of calendar tables
  • Create and manage RLS Roles

Prerequisites: Campers should have experience developing and debugging .NET applications using C# and Visual Studio.

Date and Time: Thursday, February 23, 2023 at 2:00 PM EST | 11:00 AM PST

Attendee Link: https://aka.ms/PowerBiDevCamp-2023-02