You’re offline. This is a read only version of the page.
6
I am using Excel to extract data from Project Web Access using Power Query.
I can connect to the PWA database without any issues and extract/manipulate extracted data as I want.
However, when planning projects, our project managers leave task dates blank until they have enough information to populate these fields. If I use Project's built in reports this behaves as expected and the dates are left blank. However, when I extract using Power Query, the data source is populated with a date, often, but not always the task's creation date, into what should be an empty/null/whatever blank field.
This is visible in the preview, so the problem isn't when the data hits Excel.
Here's a screenshot of what the fields I'm interested in look like in Project:
As you can see, some dates are missing as the project manager doesn't know what they will be yet until they have finished planning.
If you run a report from Project it shows the blanks. For example:
But when I run Power Query, I see this:
Note that it has assumed that all of the start and finish dates are the same as the Engineer Booking #1 task - except Execution, but that's a summary task - although this has blanks in it which have been auto-populated. The latter is probably another manifestation of the problem I expect.
Share
Report
All responses (
Answers (
StartDateFixed= Table.AddColumn(
#"Added Custom", "FinishDateFixed",
each if [IsManuallyScheduled] = true and [FinishText] = null
FinishDateFixed= Table.AddColumn(
#"Added Custom", "FinishDateFixed",
each if [IsManuallyScheduled] = true and [FinishText] = null
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
