A blog on Power BI, Modern Integration & the Azure Data Platform
I am a fan of using semantic versioning (a.k.a. SemVer) for data solutions, following the v1.0.0 pattern. It helps in the communication between team members and stakeholders, by limiting ambiguity and misunderstandings related to the version of your solution’s releases. With semantic versioning, the trick is to increment…
If you’re working with multiple Azure Databricks workspaces at the same time it can be very hard to keep those workspaces apart. Personally I struggled to keep track of the dev / tst / acc / prd workspaces. Luckily, Henko had the answer: color them differently! Of course,…
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…