Power BI, PowerShell and Azure Functions Deep Dive

This video shows you how to use Power BI's PowerShell commandlets and call those in an Azure Function to allow you to run them fully automated.

This covers how you can authenticate to Power BI via a Service Principal account with either an application secret or a client certificate. I also show you how to provision the AAD application, the Azure Function resource, and configure the Azure Function to enable this to work.

Please note that accessing the read only Power BI API's with a Service Principal is preview as of today (2/27/2021).

Sample code on GitHub below,

Intro: (0:00)
Create AAD App: (1:26)
Power BI Admin Settings: (3:51)
Read Only APIs: (4:21)
PowerShell Locally: (4:38)
Sovereign Cloud Config: (8:28)
First Full Script: (8:55)
Create Azure Function: (11:22)
Module Dependency Config: (11:49)
Create Azure Function Script: (12:56)
Blob Storage Output: (14:25)
First Azure Function Test: (14:57)
Using Environment Variables: (17:11)
Client Cert Auth: (19:04)
Wrap Up: (22:16)

[ZachRenwickData]

I was really struggling to get the PBI service app to work correctly, thanks for showing all the steps!

[snowke]

Thanks for putting this video together. I appreciated the step-by-step approach of this video, especially as I'm currently working on automating more and more of what we do in Power BI.

[AyanMullick]

More PowerBI PowerShell videos would be great. Thanks for the video

[shantanudeshmukh]

Hi Steve, This is very nice and exactly what I need to do. One question though, how do I trigger this function (HttpTrigger) from an external applications? Can you please explain this? We are trying to trigger it using Autosys. Is there any possibility of triggering this function using autosys?

[belhajkhouloud]

Hi Steve, I have tried what you have done step by step. But the part of the azure function doesn't work for me, I'm having the follow error : Could not load type from assembly 'System.Core, Version=4.0.0.0, Culture=neutral, :Type :
Do you have any idea of how to resolve this issue related to azure functions ?

[renetaffin]

@Steve Winward
Thanks for your video. I tried the same with the DataGateway module but the next instruction finishes in time-out
-ApplicationId $appid -ClientSecret $securePassword -Tenant $TenantId
The requirements.psd1 file has been configured this way 'DataGateway'='3000.*'
Do you have an idea? Let me know

[renetaffin]

Thanks for your video. I tried the same with the DataGateway module but the next instruction finishes in time-out
-ApplicationId $appid -ClientSecret $securePassword -Tenant $TenantId
The requirements.psd1 file has been configured this way 'DataGateway'='3000.*'
Do you have an idea? Let me know