You can use the free PowerBI.com license with Microsoft Project Online to do your basic reporting. There are caveats but I’ll show you ways that you can use the free license effectively.
What is Power BI?
Microsoft Power BI is a collection of online and client tools that enable organizations to visualize and explore data, share insights and allow consumption of these insights from multiple platforms.
PowerBI.com is the home site for the service and serves as the portal to see your dashboards. Power BI supports three primary entities:
- Dashboards – A tile based way of showing you important information in a glance-able and easy to use fashion. Dashboards also support natural language querying, where the viewer can type in a question and have Power BI build a new visualization automatically.
- Reports – Are similar to dashboards in that they are tile based. However, reports are more interactive in that clicking on a bar in a chart filters everything on the report. A given Power BI project can have up to 10 reports.
- Datasets – These are sets of data that have been transformed into business-usable formats.
Power BI is available on all mobile platforms via mobile applications in the platform app stores.
Yes! Awesome isn’t it! When Microsoft last updated the Power BI pricing plans, they came out with a free license tier. To get your license, go to http://PowerBI.com and login with your Office 365 account. Note, you can sign up with other accounts but if you want to use this license with Project Online, you have to sign up with the account with which you access Project.
You need to download and install Power BI Desktop to create and publish your BI content. Think of Power BI desktop as “Word for Reporting”. You put it all together in Desktop but this isn’t where you would typically consume your BI content.
For this approach to work, three things have to be true
- Your report consumer wants to consume the data but desires accessibility over the ability to customize the views
- The total amount of data you need to make available is less than 1G
- Automatic daily refresh of data is acceptable
The second point is important as the data stored counts against both the creator of the visualizations and the consumer. The last point is the norm for most Project clients as most information is updated weekly.
Publish the Report Pack
- If you aren’t already signed up for PowerBI.com, create your free account using the same account you access Project Online.
- If you haven’t already done so, download and install Power BI Desktop,
- Create your Project visualizations as you normally would.
- When finished, publish it to PowerBI.com using the Publish button.
- Open PowerBI.com
- Hover over the dataset for your report, in this case, Project Report
- You will see an ellipsis button appear on the right. click it
- Select Schedule Refresh
- Expand Data source credentials and enter your Office 365 credentials for Project Online
- Expand the Schedule Refresh section and set up when you wish the data refresh to happen
- Click Apply
Share the Report
Content Packs, which is a way of sharing report packs that allows the report consumer to customize the reports to their liking. However, creating and consuming Organizational Content Packs is a Pro only feature. You can consume the Microsoft supplied content packs with the Free license.
This is where the requirement that the end user is a simple consumer comes into play. The free license level can share their dashboards and reports with other free users. It simply makes the dashboard read only. For those tiles that support drilll-through, you can still access the reports.
- Select your dashboard in the Dashboards group on the left pane
- In the upper right corner of the screen, select the Share button
- Enter either individual emails or preferably, AD groups with which to share the dashboard. These email addresses have to be within your organization.
- Click Share
By default, everyone who is on the share list will get an email. The Report consumer will now see the shared dashboard under their dashboard section when they log into PowerBI.com. If they are using any of the mobile PowerBI clients, they will see the new shared dashboard there as well.
Please note, if you change the dashboard, the people with which it is shared will see the updates immediately.