Daniel Bell's avatar

posted by
201 views

Flow integration with SharePoint Online list and libraries

Below is an Office 365 Message Center Update:Updated Feature: Flow integration with SharePoint Online list and libraries MC96049 Published On : March 13, 2017 Expires On : April 20, 2017 In our next wave of updates to Flow in ...


Daniel Bell's avatar

posted by
219 views

“Last Connect” column no longer shown in Project Online

Why it was removedThe rationale for removing this field was because keeping the field current was an expensive operation.  Because of this it was impacting users sporadically in a negative way:Logging into PWAMoving betw ...


Daniel Bell's avatar

posted by
301 views

Project Online: OData improvements to include timestamps for project entities

Below is an Office 365 Message Center UpdateProject Online: OData improvements to include timestamps for project entities MC96752 Published On : March 18, 2017 Expires On : April 30, 2017 To improve the Project Online OData s ...


Todd Shilhanek's avatar

posted by
320 views

Merging and Expanding Queries in Power Query

When using Power Query (Get & Transform) in Power BI and Excel, you have the ability to merge queries together and expand the dataset to view all the columns in your merged dataset.While you can do this in Power BI, the i ...


Todd Shilhanek's avatar

posted by
223 views

Improving Data Refresh with Power Query Options

I have been helping several customers recently with their reporting performance issues. The reports themselves performed well, but the data refresh took forever. There are two simple steps in Power Query for Power BI and Exce ...


Daniel Bell's avatar

posted by
176 views

New feature: Expanding file management in modern SharePoint Libraries

MC94253 Published On : February 21, 2017 Expires On : March 22, 2017 We previously rolled out the modern Copy/Move command bar button for OneDrive for Business. We’re now enhancing that capability to First Release tenants for ...


Daniel Bell's avatar

posted by
339 views

Microsoft Project Server 2013 - Root Element is Missing

We were dealing with this issue today when attempting to save a rather large project schedule.  The project would create the getting queued message in the queue them immediately fail.  We knew that meant the informa ...


Daniel Bell's avatar

posted by
210 views

Microsoft Project Professional 2013 support with Project Online

Below is a communication from Microsoft regarding the version of Project Professional used to connect to Project Online.  Currently users may use version 2013 and 2016.  Beginning June 30, 2017, Project Online will ...


Daniel Bell's avatar

posted by
230 views

Creating a Microsoft Project Online Major Milestone report with Excel

Learn how to create a Major Milestone report for Microsoft Project Online using Excel and Power Pivot in this video.  We cover every step from creating the data source, adding a calculating field, to formatting the repor ...


Daniel Bell's avatar

posted by
362 views

Your queue job CreateWssSite failed: Microsoft Project Online

Upon publishing a project we were receiving an error in the queue with the title “Your queue job CreateWssSite failed. Please contact your administrator for assistance.”Embedded in the long error was the following:<?xml ve ...


Daniel Bell's avatar

posted by
510 views

PowerBI DAX: Create SUBTABLE with Filter

Today I was working with the Project Online Projects and ProjectWorkflowStageDataSet tables in PowerBI.  I wanted to created a chart that showed data points that involved workflow status, projects, tasks.  The many ...


Daniel Bell's avatar

posted by
584 views

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

Recently had a customer that was receiving an error when attempting to save a project.  The project had in excess of 5000 lines.  Project Professional produced the rather vague error you see below.