How to get schedule data from MS Project Online to PowerBI

[frame242]

Hello,

I created a new MS Project Online and I connected that to my MS Project (Desktop).

Now, I see the schedule data in MS Project Online but I cannot get the schedule data to PowerBI through the API.

Can someone let me know how I can get my schedule data from Project Online to PowerBI?

Thanks!

[v-easonf-msft · Accepted solution]

Hi,  @frame242 

You can try to use the Project Power BI template to import and analyze data from Project for the web and Project Online into Power BI.The template is designed to help you quickly connect to your Dataverse instance in Dynamics 365 where your Project for the web data is stored, as well as connect to your Project Web App tenant in Office 365. You will be able to download a variety of data to visually explore and monitor all the key aspects of your PPM deployment. There are multiple visually rich report pages for the portfolio, resource, and project overview.

Please refer to  this document for more details.

connect-to-project-for-the-web-data-through-powerbi-desktop 

You can also try to connect to Project Online with OData.

desktop-project-online-connect-to-data 

Project Online Power BI Template App:

project Online template file

Best Regards,
Community Support Team _ Eason

[frame242]

Hi Community Support,

Thanks for sharing this information.

I am trying to get the schedule data from Project Online using the API connection. Unfortunately I am unable to see this data there.

Do you know how I can get access to this data from PowerBI? (refer to image below)

Thanks!