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.
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
@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:
I used Services to connect to PWA and loaded the project data, still it only pulled out the milestone tasks. Please advise.