cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuxin Frequent Visitor
Frequent Visitor

Import Project Web App data, then dataset only shows milestone tasks

I tried to use PowerBI to visualise my project status from Microsoft Project Wed Application (PWA) by following the steps below:

 

1) clicks PowerBI from PWA dashboard, it runs the import and after it finishes,

2) open Dataset from PowerBI

3) use a table view, and drag the item "Task Name" from "Tasks" list

4) then in the table view, it shows only milestone tasks

 

Double checked filters, and for "Is Milestone" value, it selects "All", though there is only one option "YES" below the "All" value, which means there are only milestone tasks.

 

Can you please advise why it does not import non-milestone tasks? Thank you.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Import Project Web App data, then dataset only shows milestone tasks

Hi @yuxin,

 

Do you want to visualize PWA data in Power BI desktop? If so, you could load data into desktop via connecting to Odata feed. Please see: Project Online: connect to data through Power BI Desktop

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yuxin Frequent Visitor
Frequent Visitor

Re: Import Project Web App data, then dataset only shows milestone tasks

@v-yulgu-msft Thank you for the reply.

 

I am using online PowerBI, not the Desktop for team collaboration. Sorry, I should not post it into Desktop forum group.

 

In the online PowerBI, when opens Get Data screen, it shows the following options:

 

image.png

 

I used Services to connect to PWA and loaded the project data, still it only pulled out the milestone tasks. Please advise.