Microsoft EmployeePower BI Dev Camp Session 17 - Building Solutions using Power Automate and the Power BI REST API
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.
Today's Session Page
https://www.powerbidevcamp.net/sessions/session17/
Sample Code
https://github.com/PowerBiDevCamp/Power-Automate-with-Power-BI
GitHub - PowerBiDevCamp/Power-Automate-with-Power-BI: Sample canvas apps, flows and custom connectors calling the Power BI REST API Sample canvas apps, flows and custom connectors calling the Power BI REST API.
Documentation
https://docs.microsoft.com/en-us/rest/api/power-bi/
Power BI REST APIs for embedded analytics and automation - Power BI REST API
This article provides an overview for the Power BI REST APIs which can be used for Power BI embedded analytics and automation.
Follow us on Twitter - https://twitter.com/mspowerbi
More questions? Try asking the Power BI Community at: https://community.powerbi.com/
0:00 Intro
3:11 Creating a Power Platform Custom Connector
20:55 Calling the Power BI REST API from Canvas Apps
37:10 Calling the Power BI REST API from Flows
43:44 Q&A Section
46:48 Automating Administrative Tasks using Power BI Admin APIs
01:02:39 Outro
#PowerBI #RESTAPI # PowerBIdevcamp #PowerAutomate