Skip to main content


Showing posts from 2016

PowerApps and Flow released

Microsoft Flow and Microsoft PowerApps have finally been released to the public after beeing in preview for some time now (some might remember PowerApps as Project Siena).

Try it out and discover the easy business value these new services provide:

PowerAppsYou have a new place to discover and run business apps.
Find and run all your business apps from a single place—Dynamics 365. •
Publish apps with PowerApps to make them instantly discoverable in your org’s dedicated AppSource gallery.
Environments provide a space to store, manage, and share.
Create dedicated development, testing, and production environments. •
Use environments to separate apps and data by geography or team. •
Get enterprise-level management and security controls.
The Microsoft Common Data Service offers powerful app-building capabilities.

Model data using a set of standard entities with schemas that support common business themes. •
Manage access …

Custom Field Editor App Released

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.

Power BI Reports will be integrated in SQL Server Reporting Services (SSRS)

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 DesktopPublish 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 browsersSupport for Tabular and Multidimensional olap cubes

More details: 

PowerBI -> PowerPoint Report

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.

PowerBI Analytics – Forecasting your turnover

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
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 updated. That’s it, now you can create simple forecasts. The method PowerBI u…

Office 365 login problems - I keep getting asked to log into Office 365. What should I do?

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 always remembered in this profile. If you want to go to another tenant, just sw…

Gantt Chart in Power BI

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

Install app for SharePoint: The file exists

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 :-).

SharePoint 2016 and Project Server 2016 in preview

Release Candidate for SharePoint 2016 and Project Server 2016 is ready for download.
Notice the installer now contains both SharePoint and Project Server. Previously it have been two different installers.
SharePoint and Project Server 2016 RC Download

If you are using SharePoint Online or Project Online you will already know a lot of the new features.
New features (among many):
 - Better mobile and touch support
 - App Launcher (Waffle)
 - Integration with OneDrive
 - Large file support
 - Resource Engagements (Project Server Only)
 - Video Portal
 - Yammer support
 - Delve (Intelligent Search)


Sys is undefined, Type is undefined

So today I came across a strange error in SharePoint/Project Online.
3 users were not able to see the Project Center, Resource Center or add new items to a document library.
The issue was clearly related to their PC's as other users had the same problem on their PC's and they didn't have the problem on other PC's.
Everybody had the same version of Internet Explorer, Same regional settings and same language installed.

In their IE log they were all receiving the following error.
SCRIPT5009: 'Sys' is undefined projects.aspx, line 124 character 219 SCRIPT5009: 'Sys' is undefined projects.aspx, line 150 character 1 SCRIPT5007: The value of the property 'WebForm_InitCallback' is null or undefined, not a Function object projects.aspx, line 656 character 1 SCRIPT5007: The value of the property '$get' is null or undefined, not a Function object shell.js?rev=YwnNMDxuVwsNnI9A1oL38w%3D%3D, line 2 character 50132 S…