07-08-2022 15:13 PM - last edited 07-18-2022 09:07 AM
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.
Follow us on Twitter - https://twitter.com/mspowerbi
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