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.

Session Prerequisites

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