mandag den 31. oktober 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:


You 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 to data down to the entity level using roles and permissions.


Manage your organization’s flows with enterprise-grade control using environments.

Use Environments to store your flows by geography or team.

Establish data-loss prevention policies to control the flow of data and the use of services within your organization.

Microsoft Flow offers more connectivity than ever—to Microsoft and third-party services.

Connect to 15 new services, including Basecamp 3, Bitly, Cognitive Services Text Analytics, Instapaper, and Pinterest.

Use Premium services like Salesforce and the Microsoft Common Data Service, which are exclusive to paid Microsoft Flow plans.

lørdag den 29. oktober 2016

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. 

torsdag den 27. oktober 2016

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

    søndag den 23. oktober 2016

    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.

    tirsdag den 18. oktober 2016

    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 uses to do the forecast is called Linear Regression, I will not go into detail about this method but a quick Google search and you can easily find good descriptions on how the forecast is calculated.   

    fredag den 30. september 2016

    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 switch profile and you are in.

    Even better, you can also set the tenant as the start page for each profile.
    When logged in with your tenant profile, go to settings and type the URL for the tenant.

    lørdag den 26. marts 2016

    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

    onsdag den 27. januar 2016

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

    lørdag den 23. januar 2016

    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)


    fredag den 15. januar 2016

    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  
     SCRIPT5009: 'Type' is undefined   
     sp.core.js?rev=7ByNlH%2BvcgRJg%2BRCctdC0w%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     sp.ui.dialog.js?rev=IuXtJ2CrScK6oX4zOTTy%2BA%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     sp.runtime.js?rev=9sKdsC9N6p2BiRk3313M7Q%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     sp.js?rev=SpGB4%2FzYmCWpwoPWNG2dsg%3D%3D, line 2 character 1  
     SCRIPT438: Object doesn't support property or method 'registerInterface'   
     cui.js?rev=k%2B4HtUzT9%2B3mSycgD7gPaQ%3D%3D, line 2 character 132  
     SCRIPT5009: 'Type' is undefined   
     sp.ribbon.js?rev=F%2BUEJ66rbXzSvpf7nN69wQ%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     projectserverscripts.js?rev=wLWEB16RvL7LvVwBTEDczw%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     pagepropertymgr.js?rev=MSfviAZ5MiJZfNsfZFcIEw%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     remotetextconv.js?rev=SvbL5%2Fn%2FylnTsF%2FASnvAng%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     webmethodmanager.js?rev=QZWPalD63GAq0Ux6QiTvww%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     projectframework.js?rev=5poW1un5idh68Af5W7%2By%2FA%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     gridsatellite.js?rev=OD4g9TDABejWnsQti9BHCg%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     utility.js?rev=6L1OxKcWB8r9YEeRFq7iYQ%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     dom.js?rev=f7dn0H6JVBq%2BJjo%2Fz2ZJRA%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     projectcentersatellite.js?rev=hlKj0a968OT2D7gm%2FuKlMQ%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     sp.ui.combobox.js?rev=166SKYsDoffDAabXKBONxw%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     jsgrid.js?rev=mx0FnsqZMQTgnLRUymCf8w%3D%3D, line 2 character 1  
     SCRIPT5009: 'Type' is undefined   
     sp.datetimeutil.js?rev=c1q2E%2FwVfTjFPk%2BMTmPvDg%3D%3D, line 2 character 1  
     SCRIPT5007: Unable to set value of the property 'GanttPane': object is null or undefined   
     jsgrid.gantt.js?rev=QeMlynX3yiGsrTWH8GAGQg%3D%3D, line 2 character 1  
     SCRIPT5009: 'WebForm_SaveScrollPositionSubmit' is undefined   
     projects.aspx, line 832 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 5898  
     SCRIPT5007: The value of the property '$addHandler' is null or undefined, not a Function object   
     shell.js?rev=YwnNMDxuVwsNnI9A1oL38w%3D%3D, line 2 character 1727  

    This didn't tell me much other than it looks like something is broken in IE. Google and Bing gave a lot of results, but all of them were  related to programming and ASP.Net. I could not find much related to SharePoint.

    After a lot of digging and trying tried something that wasn't related to any of the errors but was a pure guess.I tried to disable the ASP.Net Compression.

    This immediately solved the problem.

    I still don't know what is the root cause, but I guess it is an error in one of the files being updated on the client PC's.