This session teaches campers how to build flows in Power Automate that call the Power BI REST APIs. The session will start with a quick primer on creating a 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 automating 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.

Session Prerequisites

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

Session Info

Date December 16, 2021
Time 2:00 PM Eastern - 11:00 AM Pacific
Attendee Link https://aka.ms/PowerBIDevCamp12162021

Sesssion Links and Resources