Data Analytics with Office 365: Part Two



In the previous post in this mini-series on Power BI, I introduced the product and briefly described how to input data for manipulation and presentation.

There’s much more to say on that topic, which I’ll dive into next time.

However, I neglected to mention a problem you might experience if you license accounts within your tenant for Power BI.


Let’s say you’ve assigned a license:




You’d expect that a user who selects the Power BI app tile from the Office 365 portal


Power BI tile


And who clicks on the Power BI for Office 365 option (“The NEW Power BI is here“)…

Power BI Landing Page


And who then sees the “Getting Started” page…

Power BI Landing Getting Started Page


Would be ready to proceed into the bold new world of data analytics.



But alas, what your user might see is this:




What’s going on?

The problem is that, by default, your tenant may be configured to prohibit users from signing up for the service on an ad-hoc basis.  For now, we’ll overlook the apparent workflow issue (after all, if you, as the tenant admin, are assigning the license it should follow that you want the assignee to use the service).

The solution is pretty simple and requires a remote PowerShell session.

To enable ad-hoc sign-ups and allow your users to proceed, issue the following Powershelgl cmdlet syntax:

Set-MsolCompanySettings -AllowAdHocSubscriptions $true

Note that to issue this specific cmdlet, you must load the Azure Active Directory Module for Windows PowerShell which gives a global admin the necessary configuration access to key elements of the tenant.

Next time, we’ll take a closer look at using Power BI to generate useful reports.