This session teaches teaches campers how to build Power Platform solutions with flows and canvas apps that call the Power BI REST APIs. The session will start with a quick primer on creating a Power Platform custom connector and configuring authentication to call the Power BI REST API either as a user or as a service principal.
Campers will learn the basics of calling the Power BI REST API to return data on workspaces, datasets, reports and dashboards. The session will demonstrate how to call the Power BI REST API from a canvas apps and how to automate common Power BI builder tasks such as importing PBIX files, refreshing datasets and exporting reports to PDF files. The session also explains what's required to call the Power BI Admin APIs in a flow to export events from the Power BI activity log and to scan workspaces to inventory the reports and datasets that exist within a Power BI tenant.

What Campers Will Learn:

  • Creating a Power Platform Custom Connector
  • Calling the Power BI REST API from Canvas Apps

Session Prerequisites

Campers should have prior experience using Power Automate. Experience working with the Power BI REST API is recommended but not required.