Patrick Lamber

Patrick Lamber - Dec 1, 2016 - Follow          
Technical consultant and Office Server and Services MVP.

Enabling Power BI for your organization

by Patrick Lamber on Dec 1, 2016
Filed under: Power BI Governance Office 365
Share it:

https://powerbi.microsoft.com allows you to create fancy and powerful dashboards for you individually or your organization. At this stage, you have the opportunity to choose between a free and pro subscription. A comparison about features and prices can be found here.

By default, all organizational accounts can’t subscribe for a Power BI (free) version. This is governed centrally by the Office 365 administrator. If you are trying to subscribe with an organizational account through the official Power BI site, you might encounter the error message below.

Your IT department has turned off sign-up for Microsoft Power BI.

Depending on the IT strategy you might want to govern how users of your organization are accessing these types of new services. As IT organization you can “purchase” PowerBI (free) licenses without additional costs. You have to follow the purchasing process for new subscriptions and select the desired option.

Alternatively, you can purchase the pro version. Afterwards, you can assign the licenses to your users.

On the other hand, if you do not care about users subscribing to free Microsoft services with the organizational account, then you have the opportunity to change the configuration over Azure Active directory with PowerShell. The script below allows organizational users to subscribe to e-mail based ad-hoc subscriptions. Examples are Power BI but also PowerApps. New services will be introduced in future and also be affected by this option. Note, that the option is global and can’t be restricted individually or by service.

The script above opens the option to the whole company for all types of applications that allow e-mail bases subscriptions. You need to be sure that you really want to have this behavior in your organization.
$msolcred = get-credential
connect-msolservice -credential $msolcred
Set-MsolCompanySettings -AllowAdHocSubscriptions $true

If you want to disable it, just use the $false flag instead of $true. This will stop users for creating new subscriptions. Old subscriptions remain untouched. The change is immediate.

After the activation of the setting above, your organizational users can subscribe to Power BI. After the successful subscription they are able to see the Power BI logo on their portal site.

by Patrick Lamber on Dec 1, 2016
Filed under: Power BI Governance Office 365
Share it: