Power BI Dev Camp Session 23 - Developing for Power BI using Azure Functions

Natalie_iTalent — Mon, 18 Jul 2022 16:07:44 GMT

This session explores the potential of developing Azure Functions for a Power BI environment to automate administrative tasks and the deployment of datasets and reports. Campers will get a quick primer on Azure Function essentials and then learn how to write and test Azure Functions that call the Power BI REST API. The session will step through the process retrieving authentication credentials from Azure Key Vault and calling the Power BI REST API as a service principal.

This session will also demonstrate a solution that responds to CSV file uploads by automating the creation of a Power BI dataset and report on top of the data in the CSV file. The session also demonstrates developing scheduled functions which call Power BI Admin APIs and save the responses in a JSON format into Azure Blob Storage where they can be analyzed and reported on using Power BI Desktop.

It is recommended (but not required) that campers have prior experience with Microsoft Azure and have access to an Azure subscription.

0:00 Introduction

1:52 Azure Functions Primer

18:07 Calling the Power BI REST API

37:08 Writing Data Files into Azure Storage

43:11 Automating Report Creation on Files Upload

52:15 Developing an SPA using Azure Functions

1:00:35 Q&A Section

1:03:15 Power BI Community Reminder

#Microsoft #MicrosoftPowerBI

watch?v=6ro4wDdF8B0

topic Power BI Dev Camp Session 23 - Developing for Power BI using Azure Functions in Webinars and Video Gallery

Power BI Dev Camp Session 23 - Developing for Power BI using Azure Functions