Todd Shilhanek's avatar

posted by
2 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
14 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
11 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
32 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
64 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
61 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
176 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
209 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
297 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.


Daniel Bell's avatar

posted by
350 views

Change permission mode of Project Online instance

Navigate to the Office 365 portal as an administrator Navigate to the SharePoint Management area Click the checkbox on front of the PWA site collection you want to change the permissions mode for Click the Project Web App ...


Daniel Bell's avatar

posted by
398 views

Shrinking a SQL 2012 log file

This method works extremely well and quick!USE AdventureWorks2008R2;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE AdventureWorks2008R2SET RECOVERY SIMPLE;GO-- Shrink the truncated log ...


Daniel Bell's avatar

posted by
581 views

WorkflowCheckinNotify Error Project Server 2013

I was receiving this error at a customer site recently.  They had no workflows setup in the system, although they did have all the necessary objects installed to deploy Project Server workflows.  In order to get aro ...


Pages: Previous1234567...62NextReturn Top