QR Codes in Power View

Jason Thomas (SQL Jason) wrote a nice post about how to add (dynamic) QR Codes to your Power View workbook in Excel 2013:


A calculated field in PowerPivot does the trick:

1) …The formula for the calculated field QRCode is given below
="http://qrcode.kaywa.com/img.php?s=8&d=" & [Brand] & "" & [URL]

2) Once the URL is generated, make sure that the Data Category property in the Advanced tab is set to Image URL.

Read Jason’s full blog post here.

Office 365 service / feature comparison

Here’s the complete overview of all features per Office 365 Edition / Version:


Microsoft also made an easy look-up thingy:


How to mount an ISO in Windows Server 2012 R2?

On Windows Server 2012 or Windows Server 2012 R2, it supports to mount ISO without any third-party software.

1, On Windows Server 2012 or Windows Server 2012 R2, log in as Administrator.
2. Launch “Windows Explorer“, navigate to C drive.
3. Right-click the ISO file.
4. Click “Mount“:


Viola! It’s mounted:


In PowerShell: You can also perform “Mount-DiskImage -ImagePath” to mount an ISO and VHD file:


To dismount the disk image, we can perform “Dismount-DiskImage -ImagePath” to dismount it:


Power BI (Office 365) pricing has been announced

Many thanks to SQL Chick (Melissa Coates) for the news!

The features you have end up being the same (more on that below). The differences shown below are only related to what prerequisites you already have in order to determine pricing.


Pricing for the E3/E4 plans is shown in the next screen shot. The importance of E3/E4 is that they come with Office 2013 Professional Plus and SharePoint Online (SPO) Plan 2 – both of which are important prerequisites for Power BI features and functionality.


Let’s say you are an E3 subscriber at $20/month. Add the $20/month special offer price for Power BI and it’s a total of $40/month per user. That’s much better pricing than the $52 shown in the far right hand column of the pricing chart. Hmmm…sounds like a price break to entice more customers to the Enterprise Office 365 plans.

Good tip! 🙂

Join us at LinkedIn!
Don’t forget to join the ‘Microsoft Power BI‘ group on LinkedIn and stay updated!: