Power BI, PowerShell and Azure Functions Deep Dive
HTML-код
- Опубликовано: 1 авг 2024
- 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).
docs.microsoft.com/en-us/powe...
Sample code on GitHub below,
github.com/SteveWinward/Power...
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) 
Наука
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.
Excellent! I’m planning on doing a follow up to this to show how you can use GitHub actions to automatically deploy updates to an Azure Function app. Stay tuned!
I was really struggling to get the PBI service app to work correctly, thanks for showing all the steps!
Glad you found it helpful!
This was awesome Steve! ✨
Glad you enjoyed it. It was a lot of fun putting this video together.
More PowerBI PowerShell videos would be great. Thanks for the video
Thank you for the feedback. Glad you enjoyed this video.
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?
@Steve Winward
Thanks for your video. I tried the same with the DataGateway module but the next instruction finishes in time-out
#Connect-DataGatewayServiceAccount -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
Thanks for your video. I tried the same with the DataGateway module but the next instruction finishes in time-out
#Connect-DataGatewayServiceAccount -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
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 'System.Security.Cryptography.SHA256Cng' from assembly 'System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.)Exception :Type : System.AggregateExceptionInnerExceptions.
Do you have any idea of how to resolve this issue related to azure functions ?
I have not seen that error before. When do you get the error? Do you get it when you try and run the function? Is the Azure function PowerShell based and not C# based?
@@SteveWinward Yes I get it when I try to run the function.It's based on PowerShell Core.I made a research and this is what I found about this issue:github.com/microsoft/powerbi-powershell/issues/288
Got it. Nice find with the GitHub issue that was submitted. It looks like this issue will be resolved by June 18! Thanks for posting the GitHub issue link with your comment!
@@SteveWinward I'm the one who have to thank you for this great video you made ! I hope this issue will be resolved soon that we can get the benefit of azure function modules.