Since the announcement of Windows Virtual Desktop (WVD) in September 2018, I have seen many different scenarios and adoption by a wide range of customers.

Chargeback Model Scenario

One of the scenarios is developing a chargeback model for IT to bill their end user’s usage back to their business unit. The most common approach is a “SaaS based” per user per month (pupm), depending on the user profile type (i.e. light, medium, heavy use).

One of the other scenarios is to calculate the total session duration by each user and charge according based on a rate. …

QR Code is still commonly used today — this simple approach even lead to a national wide implementation of location check-in using an unique QR code for every location. This article aims to address how you can create your own QR Code programmatically internally without the use of public available options.

Photo by Roman Grachev from

QR Code, in short for Quick Response code, is a code that can be quickly readable (a couple of seconds) by a device with a camera attached. QR Codes are commonly used today across various industries such as logistics, retails, marketing and social media. In recent times, QR code…

Looking back

During the initial outburst of the global pandemics in February 2020, I created a few approaches using a mix of Power Platform (e.g. Power Apps, Power Automate, Power BI, Microsoft Forms) — COVID-19 dashboard, contact tracing for internal organization and external parties (also with the encouragement of a fellow challenger Jeffery Tay). I have also open-sourced my project on my git for public to extend on.

Contact Tracking Canvas App using Microsoft Power Apps

It was fun to push the extent of technology with the various use cases and subsequently, there was an “explosion” of solutions built to assist organization. …

One of my customers saw this dialog box while doing user assignments to application groups in their Azure Portal for Windows Virtual Desktop.

Setup email discovery to help your users discover their resources using an email address instead of the deployment URL

Snippet on User Assignment for Application Groups in Windows Virtual Desktop blade — Azure portal

To connect to Windows Virtual Desktop, there are a couple of ways using different form factors/operating systems:

If you are using the Windows Desktop Client and Web Client, it is relatively easy as user will just need to sign in with their user account and their associated…


In my earlier post, I did a quick simple hack to develop a Contact Tracing app using Power Apps for internal (organizational) users to do check in on their known location(s) to facilitate contact tracing if needed in an event of an epidemic outbreak.

For those who miss my previous post, you can get it from here (link).

New Problem Statement

In another scenario where the use of Power Apps is not possible for whatever reasons, the next best alternative is the use of Microsoft Forms.

Jeffery Tay shared his method to automate the mass creation of Microsoft Forms using Selenium — writing…

How this got started

One of my contacts reached out to me with an idea to leverage on Power Apps to create an app for internal (organizational) users to do a check in on their known location(s) to facilitate contact tracing if needed in an event of Novel Conorovirus suspected case.

Birth of the idea

The initial thought was to create a Microsoft Forms for every single known location in the organization and users have to fill up the form whenever they are in that specific location.

The challenge here is — if you have 100 locations, you need to create 100 unique Microsoft Forms which goes…

This is a series for Modeling Wuhan Coronavirus (2019-nCoV) Global Cases Dashboard with Power BI . For the rest of the series, please refer to links below:

In this last post, I will address on the Advanced use of Power Query to consolidate all the existing sheets and aggregate the data to form this visual based on the Google sheets provided by JHU CSSE.

For those whom have missed the previous post, you can…

In my earlier post, we have used the set of data provided by Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE) and built a tracking dashboard using Power BI. With some tweaks using Power Query, we are able to pull the sheet with the latest data and reflect it on Power BI.

In this short post, I will share on publishing the Power BI file together with the data set and setting data refresh schedule.

Publishing the file to Power BI Service

After finishing the Power BI file on Power BI Desktop, you can publish it to Power BI Service. …

Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE) developed an online dashboard (as shown below) to visualize and track the reported cases on a daily timescale using ArcGIS.

ArcGIS Dashboard developed by JHU CSSE

They have also provided the complete set of data which is downloadable as a Google sheet, consolidated from various sources, including WHO, U.S. CDC, ECDC China CDC (CCDC), NHC and DXY.

How about trying to create a similar visualization with the public set of data on Power BI?

Below will be the outcome which we hope to develop on Power BI and is can be accessible via

This is a continuation of a 8-days series of Power Platform. For the rest of the series, please refer to links below:

TL:DR — Day 3 Recap

I have to admit — Day 3 seemed tad long because of the depth I went into Common Data Service (CDS) and Common Data Model (CDM). I felt that this is an area which was not clearly addressed and misunderstood in the community. …

Jenzus Hsu

Closet geek, on the cloud journey with @Azure. Love Baseball. Git + LinkedIn: jenzushsu

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store