A blog on Power BI, Modern Integration & the Azure Data Platform
In addition to adding a Service Principal to all Power BI workspaces, it is also useful to have a script for removing, right 😃? Check out the RemoveServicePrincipalFromPowerBIWorkspaces.ps1 gist on GitHub. It’s also framed below (same script). Script details This script will prompt for the (correct) ObjectId of…
The Microsoft Ignite 2020 virtual conference is starting today! It is online and free to attend. If you have not registered, do it quickly! As there are over 800 sessions, it can be overwhelming to build your schedule and find the things interesting for you. I want to…
I’ve created a PowerShell script that will add a given Service Principal to all (configured) Power BI workspaces. This can be useful or even required for all kinds of scenarios, but I recently needed such a script for my BPAA solution as it needs to talk to the…
Ever since the XMLA endpoint came available for data models in the Power BI service, I’ve been thinking about a way to use the Best Practice Analyzer of Tabular Editor to check all the existing data models in the Service in a single batch. And now it’s ready!…
Every now and then I need to draw a diagram for a solution or platform architecture, and enjoy doing that! I usually spend more time on them then planned 🙄. There are lots of tools to create these diagrams, and lately I have been primarily using draw.io and…
This is part 3 of my series on ‘Automatic TeslaCam And Sentry Mode Video Processing In Azure’. Check out the overview post, or the 2nd post about how to configure the Azure resources. In this post, I describe how to configure a RaspberryPi to run the TeslaUSB project,…
This is part 2 of my blog post series on ‘Automatic TeslaCam And Sentry Mode Video Processing In Azure’. Check out the overview post if you have not done so already. In this post, I describe the Azure resources you need for this solution. When in doubt, drop…
This is part 4 of my series on ‘Automatic TeslaCam And Sentry Mode Video Processing In Azure’. Check out the overview post if you have not done so already. In this post, I describe the Azure Function App that orchestrates the processing of the videos using the Azure…
TLDR: With this solution, you will get a notification on your phone with direct links to the TeslaCam and Sentry Mode footage of that day, after you arrive home and the automatic processing of the videos is completed. To save time reviewing the videos, the 4 different video…
This is the second blog post in a mini-series about a new and exciting approach to model and serve data using CDM folders in Azure Data Lake Storage, in conjunction with Power BI dataflows. This blog post focuses on how to create those CDM folders using a set…