PPM Tricks

Want to know which custom fields you are using and which you are not. It can be difficult to s figure out just by looking in PWA-Settings. Luckily a new app that gives you exactly this overview has just been released. Find  Custom Fields Editor  in the Office/SharePoint store.  The app is free for now but that might change in the future.  So install it now! The app gives you a simple overview of your custom fields and how many projects that have used them. If a custom field have never been active on a PDP chances are no project have assigned values to them. You can also export the table to Excel to keep track of the development in the Microsoft PPM system.  

According to the latest preview of SQL Server Reporting Services, it will soon be possible to publish your nice PowerBI reports to reporting services. Visually explore data and create an interactive report using Power BI Desktop Publish that report to an on-premises report server (SQL Server Reporting Services) Share the report with your coworkers so they can view and interact with it in their web browsers Support for Tabular and Multidimensional olap cubes More details:   - https://powerbi.microsoft.com  - https://ideas.powerbi.com

A great new feature became available in PowerBI this week. Export to PowerPoint. Go to any PowerBI Report (does not work for Dashboards yet) and click on Export to PowerPoint: That’s it, now you have a PowerPoint report to show off at the steering committee or to send to the executive management.

This is a short update on the new, still in preview, feature that allows you to create forecasts on time phased data. I am personally very exited about this feature as it very easy gives you the possibility to create a “guess” on how your business will look in the coming years  . So, diving in. Take the turnover in your business and activate the forecasting feature. You will get calculated forecast on what your turnover might be in the coming years and a high/low estimation of what will happen. So how do you activate it? First we need to activate the preview feature (note that this feature is still not available in PowerBI.com. Then you need a dataset with at least a date column and a value column. Now, create a new line chart and add the two columns (dates and values).   Go to the new Analytics tab and add a new forecast. Set the forecast to the desired number of forecast points (20 in my case) and see he chart being update...

If you are using multiple different Office 365 tenants you have properly seen below login screen way too many times. (sorry for the Danish screenshots) Every day I spend a lot of time finding passwords and login information to different tenants. To overcome this problem and have a very easy way to login to all tenants simultaneously I found a cool feature in Google Chrome today. Profiles is here to save you Create a profile for each tenant and use these profiles when you want access the tenants. 1. Start Google Chrome 2. Go to Settings 3. Scroll down to persons/users and add a profile for each tenant. (I have a profile for a tenant called 365 and one for a tenant called DevProj ) 3. Give the profiles a cool icon like the Ninja or the Flower. 4. Now right-click the default profile and select one of your new profiles. 5. Login, for the last time, to the tenant. (do not forget to check the Remember Me checkbox) Now you are al...

The product team have released a new tile for Power BI which can make a very nice representations of a Gantt Chart. Blow is an example of what the Gantt chart in Power BI Designer. The tile can be downloaded here . To use the tile, simply download it and import it to Power BI Desktop. The tile have a number of fields and measures, if you have trouble figure them out you can download my sample .pbix file here

If you have the below error in Visual Studio when you try and debug a SharePoint App: Severity Code Description Project File Line Error Error occurred in deployment step 'Install app for SharePoint': The file exists. (Exception from HRESULT: 0x80070050) [AppName]  0 You have properly already tried:  - Clean the solution  - Manually uninstall the solution  - Upgraded the App version number  - Retracting the solution If none of the above works and you are pulling your hair for a solution, try and run Visual Studio in Administrative mode . This have fixed the problem for me many times and i think it was time to share it :-).