#ProjectServer and #SharePoint 2010 / 2013 August 2015 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

August 11, 2015 at 6:54 pm | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Leave a comment
Tags: , , , , , , ,

The Office 2013 August 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-gb/kb/3083805

Project Server 2013 August 2015 Server Roll up package:
https://support.microsoft.com/en-gb/kb/3055005

Project Server 2013 August 2015 CU:
https://support.microsoft.com/en-gb/kb/3055018

Project 2013 August 2015 CU:
https://support.microsoft.com/en-gb/kb/3055022

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the August 2015 CU.

The Office 2010 August 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-gb/kb/3083805

Project Server 2010 August 2015 Server Roll up package:
https://support.microsoft.com/en-gb/kb/3055038

Project Server 2010 August 2015 CU:
https://support.microsoft.com/en-gb/kb/3055046

Project 2010 August 2015 CU:
https://support.microsoft.com/en-gb/kb/3055050

SP2 is a pre-requisite for the Office 2010 August 2015 CUs.

As always, fully test these updates on a replica test environment before deploying to production.

#ProjectOnline reporting using #PowerBI Part2 #BI #Office365 #Reports #PPM #PMOT

August 7, 2015 at 4:01 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Functionality, Information, Reporting | 2 Comments
Tags: , , , , ,

This is the second post for the Project Online reporting with Power BI intro I created earlier this week. If you missed it, a link to the post can be found below:

https://pwmather.wordpress.com/2015/08/04/projectonline-reporting-using-powerbi-part1-bi-office365-reports-ppm-pmot/

In this post we will look at creating new reports using the Power BI Desktop tool then adding these to Power BI.

Firstly if you haven’t already, download the Power BI Desktop: https://powerbi.microsoft.com/desktop.

Once launched you will see a getting started type page:

image

Close this and you will see a blank canvas:

image

The first thing we need to do is get the data, to do this click the Get Data button on the ribbon then OData feed:

image

In the  next window, paste in your Project Online OData feed, in this example I am using:

https://cpsppmdemo4.sharepoint.com/sites/PWA2PSMODE/_api/ProjectData/Projects

image

Click OK and you will see your data:

image

At this point you can click OK to load the data but I would Edit the data to only select the fields you want. So in this example I will click the Edit button to load the query editor. The Query editor is very similar to the Power Query editor you see in Excel:

image

I only want certain columns so I will select the columns I want then remove the others. To select the columns just click the first one and hold down the Ctrl key then click the rest:

image

Or use the Choose Columns button on the ribbon:

image

Once all selected, click the Remove Columns > Remove Other Columns:

image

Notice in the Query Settings pane you see the Applied Steps, so you can easily undo a step if required:

image 

That is the project data loaded, now I want to load the task data. In the Query Editor click New Source > OData feed:

image

Paste in the URL for the Tasks feed:

image

Click OK to add the new source. I then selected the columns I wanted and named the query:

image

There is also an advanced editor that I used to filter out the summary tasks by modifying the URL:

image

The advanced editor can be used to type the code to manipulate the data but use the UI where possible.

Now we have two individual datasets / queries, we need to merge the queries to create the join, click the Merge Queries button:

image

Chose the columns and table to join then the join type:

image

Click OK.

Once you are happy with the data click Close & Load > Close & Load:

image

This will load the dataset to the report, see the fields pane:

image

Then add your visualisations on, the first one I added is the Treemap:

image

Then drag the fields to the visualisation settings on the pane, in this example I use Project Name for the group property and % complete in the values property:

image

Add the other visualisations you need, the example I created looks like this:

image

I then added another page to visualise some task information:

image

A very basic report but that gives you the idea how easy it is to create visualisations of your Project Online data using the Power BI Desktop.

The next stage is to add this to Power BI. To do this I can either publish the report using the Publish button or from the Power BI site, upload the file. For this example I clicked the Publish button:

image

The report will then be available in Power BI. The manual way from the Power BI portal site is to click the Get Data button:

image

Then chose the type of data, for this example I will use Files:

image

Then click local file:

image

Locate the Power BI file (or can be Excel etc. but this was a Power BI file) and add the file:

image

Once loaded, Power BI will create the dataset, the report and create a dashboard with a link to the report (note, I removed everything from my Power BI portal so that is was clean for the screen shots :))

image

Clicking the link under the Reports heading will load my report:

image

Clicking on an element from a visualisation will filter the data in the other visualisations:

image

The first thing to do is set up the dataset to refresh, to do this click the ellipsis next to the dataset then click Schedule Refresh button on the fly out menu:

image

Expand Manage Data Sources:

image

Enter the credentials for both sources, click the Edit Credentials link, select the oAuth2 for the Authentication Method and click Sign in:

image

Enter the credentials for the Project Online tenant and click sign in. Repeat for the other data source.

Now expand the Schedule Refresh section and turn on the “Keep your data up-to-date”:

image

Click Apply. The data sources will update Daily now but you can also update it on demand using the Refresh Now option:

image

When the data is refreshing you will see a spinning icon next to the dataset:

image

Now lets look at the dashboard. I will create a new Dashboard called “Dashboard Example” using the + button next to the Dashboards heading:

image

Once created you will see a blank canvas:

image

Now I can pin visualisations to this dashboard. To start with access the report previous loaded, hover over a visualisation and click the pin icon:

image

Navigate back to the dashboard and you will see the visualisation:

image

Repeat this process until you have the dashboard you need, for example:

image

You can also create new visualisations from the dashboard using the natural language query “Ask a question…” field, start typing a question about the data, for example “show project work” will create a visualisation for the total project work in the dashboard:

image

This visualisation can then be pined using the pin too. You can also change the default visualisation for the data returned using the visualisation pane, see the example below for a different query:

image

Once finished, the visualisations can be been seen on the dashboard:

image

The properties of the tiles can be edited using the pencil icon:

image

This loads the Tile detail pane:

image

Clicking on a visualisation that was added from a report will navigate you to that report directly.

You can then share your dashboard out to other people in your organisation using the Share Dashboard option, this loads the following window:

image

Enter the email addresses and click Share.

This is just touching the surface of what you can do with Power BI, take a look today – it will be your favourite reporting tool!

#ProjectOnline reporting using PowerBI Part1 #BI #Office365 #Reports #PPM #PMOT

August 4, 2015 at 6:01 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Functionality, Information, Reporting | 3 Comments
Tags: , , , , ,

Since Power BI 2.0 was released a week or so ago I thought it was time I created a blog post on Power BI and show off some of the cool functionality Power BI has to offer. In this first blog post we will take a look around Power BI and see what it has to offer and include some useful links to help you get started.

So firstly, what is Power BI? In short Power BI is a cloud reporting tool that enables you to create great visualisations for your data. I won’t go into details here as there is plenty of information available – a good place to start is here: https://powerbi.microsoft.com/tour

On my Power BI instance I have created some example reports and a report dashboard already as you can see below:

image

Displayed above is my example Report Dashboard displaying various visualisations for % complete, Work and Cost.

The first thing you need to do before you can create the dashboards is get the data available in Power BI. You can do this by clicking the Get Data button. This will load the screen below:

image

In my example I selected the Files option and loaded up a file that contained my data. This could be an Excel file, CSV file, Power BI Desktop file etc. As I wanted to see my Project Online data here I chose a file I had already created earlier using Power BI Desktop that displayed my Project Online data – more on Power BI Desktop in a later post when we look at creating a new report and dashboard.

Once the report file is added you will see it appear under the Datasets heading on the left navigation pane and under the Reports heading:

image 

Clicking on the link under the dataset enables you to create new report:

image

Clicking the ellipsis allows you to refresh the data or schedule a refresh. This functionality will depend on the data source you use in the file – for Project Online OData, both of these work:

image

Firstly you will need to click the schedule refresh option, expand Manage Data Sources:

image

Click Edit Credentials then chose oAuth2 and click sign in then enter the credentials for a user that had access to the OData API.

Clicking on the link under the Reports heading displays the report file I uploaded as a data source (created in Power BI Desktop but could be Excel etc.):

image

From the report you can add visualisations to the dashboard using the “Pin Visual” pin option. This becomes visible when you hover over a visualisation on the report:

image

You can create many different data sources, reports and dashboards. From the dashboard you can click a visualisation and it will drill down to the report itself. In this example if I click on my % complete treemap visualisation on the dashboard it will load the source report:

Clicking the treemap:

image

Loads the source report:

image

From the dashboard I can also create new visualisations and pin those, to do this I can use the natural language search – use the “Ask a question about the data on the dashboard” field:

image

For example, I might want to see a count of projects for each project owner, so I start typing “count of projectname by ProjectOwnerName”:

image

You can see Power BI already started to get the data and create a visualisation that matched the data type. Once I had finished typing my query it gave me this:

image

You can then change the visualisation using the options on the right hand pane, in this example I switched it to a multi row card:

image

I can then use the pin to pin the visualisation to my dashboard:

image

Clicking the pin will give you a notification and add the visualisation to the dashboard:

image

Now if I look at my dashboard I can see it has added the new visualisation at the bottom:

image

Next up I will walkthrough creating a new report using Power BI Desktop and load that to Power BI.

In the meantime here are some useful links for Power BI:

Power BI site: https://powerbi.microsoft.com/

Power BI overview: https://support.office.com/en-US/article/Power-BI-Overview-and-Learning-02730e00-5c8c-4fe4-9d77-46b955b71467 

Support: https://support.powerbi.com/

Power BI blog: http://blogs.msdn.com/b/powerbi/

Blog at WordPress.com.
Entries and comments feeds.