Wednesday, May 31, 2017

New projects and sites number limit & EPT configuration

Beginning of April, Microsoft announced in this article of few improvements, mostly related to Project Online performance, such as the new check-boxes in the Project Center I described in my last post. Another major improvement concerns the limit of projects created in a Project Online instance increased from 5,000 to 30,000. With this improvement comes another one concerning the project sites. The limit used to be 2,000 project sites. If you needed more than 2,000 sites, you had to create and work with several PWA instances. Now there is a one-to-one relationship, meaning that you can have 5,000 projects with 5,000 sites.

In order to optimize PWA instances performance with those news projects and sites limits, the EPT (Enterprise Project Type) configuration has also been updated. 
Previously the synchronization settings were at instance level, they are now at EPT level. Moreover, you can set a site creation location for each EPT. 

How you should use this new configuration? Here is how I see it. 
  • You might have an EPT with a large number of small projects running on a short period. In this case, you'll not create any project site and consequently you'll not check the sync permission options.
  • In parallel you might have another EPT with an small number of standard projects. In this case, you'll automatically create a project site, you'll check the sync options and locate the site creation in the normal PWA address.
  • Finally, you might have an EPT with specific long term projects dedicated to specific stakeholder with a large set of documentation. You'll also automatically create a site with sync options checked, but you'll locate the site creation in another site collection.

Consequently, since those options have been rolled down at EPT level, you won't see them anymore where they used to be. If you go to the Connected SharePoint Sites section in the server settings, you'll see that there is no more "Settings" button.

Also under "Manage User Sync Settings", you won't find anymore the site sync.

Check-out the Microsoft blog to see the other improvements, such as the modified dates added to some Odata entities.

What is happening if you already have some project sites created in the "old" way? (a jérome's edit)?

Well, the story is a bit more complicate then. By default, you have to know that the options are not as set as you would expect.
1. While the Project Site creation will be set to the choice which was made in the "old" menu

2. The synchronization options are both disabled. The impact is that all the team members are losing (or not gaining) the access to the project sites while the project is published. Tasks as well stops to be synchronized which means that no more seen in the home page nor in the tasks menu of the Project Site

It is also worth noticing that the Project site is now created at next publish and not at project creation as it was previously enabling a rapid project creation

So, to wrap-up, if your environment is already having project sites created, I would advise the to take the following steps:
1. Validate that the setting for each Enterprise Project Type is the expected one
2. Open the schedule and publish it (either from Project Online or from Project Professional) - that will trigger a tasks synchronization
3. Change your project team temporarily in adding or removing a resource (who can connect) and publish to trigger the Project Site Permission Synchronization. Then revert the change.

You should now be good to go. let me know if you find any weird behaviours, Guillaume and I would be happy to further complement that post.

As a cross-reference, I would like to link the great work done by Nate Auchter here

Share this article :

Friday, April 21, 2017

Project Center update: small change good change!

Hi Folks,

You've got to stay on track with updates, which is not always obvious with the frequency of updates in Project Online!

Did you notice? No? Have a look to your project center ribbon... 

Got it? You have 2 new check-boxes, rollups and Gantt Chart. Quite easy for the second one, you can hide or display the Gantt Chart. I guess the first use concerns portfolio views where Portfolio Managers want to focus on data more than on the Gantt aspect.

The second one can be interesting also. You can hide or display rollups while using grouping data in views. The objective might be to load faster views

This could propose this type of interesting portfolio views.

Share this article :

Tuesday, March 28, 2017

PowerBI dashboard integration in Microsoft TEAMS

Hi Folks, it's been a while! Back from a couple of very time consuming projects, I wanted to share with you a nice way to share PowerBI dashboards.

A couple of months ago, I wrote a post about how to embed a PowerBI dashboard in SharePoint/Project Online using a content editor webpart. That was a nice try, but if you read it until the end, you probably saw this disclaimer:

Warning: When you use Publish to web, the report or visual you publish can be viewed by anyone on the Internet. There is no authentication used when viewing these reports. Only use Publish to web with reports and data that the anyone on the Internet (unauthenticated members of the public) should be able to see. Do not use Publish to web with sensitive data, data that has financial implications, data that must remain confidential, or data that you do not have the license rights to publish.

Not good, isn't it!? Or at least pointless... Until then, you couldn't easily share a PowerBI dashboard out of PowerBI App.

Few weeks ago, Microsoft released TEAMS, a chat-based application for supporting team collaboration (see here for more details), accessible from the O365 waffle menu.

O365 Waffle menu with TEAMS
The principle is quite simple. Assuming you have created your PowerBI dashboard and configured your collaboration space in TEAMS, you can easily add in the teams section a PowerBI application.
Add a PowerBI application in TEAMS
Once done, you'll be prompted to choose among the PBI dashboards you can see.
Select PowerBI dashboard
That's done!
The good thing is that it isn't just an image of your dashboard but a frame embeding your PowerBI content. You can even play with the filter or start a discussion related to the dashboard.
Use the dashboard filter in the TEAM PowerBI tab

Start a conversation about the dashboard

Beyond this nice feature, I see advantages for organizations using teams which can create groups of users based on their reporting needs, such as portfolio managers, and share dashboards accordingly.

Share this article :