Power BI to Show Resources from Project Web

[chippy55]

Hi! I'm new to MSFT and all of it's products so please remember that when replying 🙂

I'm managing a team of creatives. All of our projects are in MSFT Project Web.  We are connected to a power BI which shows an over view of project status. On time, late, etc.  What it doesn't show is what the team is doing.

I want to be able to look at a calendar and see that Joe is booked from July 1 - July 10 for 4 hours a day and from July 7 -July 10 for 6 hours a day which would show me that he is over booked for 4 days.

I've downloaded several calendar and gantt chart visuals, but nothing is panning out.  When I try to filter by tasks, it just goes blank.

I'd appreciate any assistance. I've Binged and haven't found anything in the forum.  it's a huge blocker for my team and we are resorting to an excel to keep track of resource allocation.  Thanks Lynn

[amitchandak]

@chippy55 , refer if one of these can help

https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-to-project-online

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-project-online-connect-to-data

https://www.youtube.com/watch?v=yAGej903VO8

https://www.analytics8.com/insights/how-to-get-data-from-ms-proj-into-your-bi-tool/

[chippy55]

Hi!  Thanks for sending.  I'm already connected and we are using Project Web, not Project Online.

I literally want to see a calendar view of who is doing what when.  

[amitchandak]

@chippy55 , Ok, see if these can help

https://appsource.microsoft.com/en/product/power-bi-visuals/WA104380765?tab=Overview

https://www.mpug.com/articles/how-to-create-an-amazing-gantt-chart-in-power-bi/

https://blog.pragmaticworks.com/power-bi-custom-visuals-as-timeline

https://www.youtube.com/watch?v=SO4mk1H94OA

https://xviz.com/visuals/gantt-chart/