Connect MS Project online desktop client with Power BI desktop

[rahul801]

Hi All,

I am trying to connect the Ms Project desktop client with power BI desktop via OData feed. I am not able to connect it says ( We couldn't authenticate with credentials provided. PLEASE TRY AGAIN). Do I need admin access to the PWA site? Do I need Power BI pro license do the connection? or can it done on Power Bi desktop free version?

Any help will be appreciated ?

Best regards,

Rahul

[rahul801]

Hi

Thank you for reply. 

Can I connect my projects in MS project online desktop client to Power BI desktop version ? since Project Web App have some limitation regarding task dependencies , total task for a project. I mean can I connect my project to Power BI without uploading it to the PWA site? 

Best regards,

Rahul

[Anonymous]

Hi @rahul801 ,

Yes, You can connect your MS Project Online data to Power BI Desktop without uploading it to the Project Web App (PWA) site

Below is the official link will help you:

Project Online: Connect to your data with Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rahul801]

Hi @Anonymous ,

What shall I enter in the OData source link when using the data from MS project online ? The official page only mentions about PWA (that confused me ) 

[Anonymous · Accepted solution]

Hi @rahul801 ,

I'm sorry, I misunderstood, sorry, at the moment, if you want to connect directly to project online's data source on top of desktop, you need to use PWA.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @rahul801 ,

To admin access to the PWA site : 

     Yes, you’ll need admin access to the Project Web App (PWA) site. Ensure that your credentials have the necessary permissions to access the data.

To power bi pro license:

     To connect to Project Online data using Power BI, you do not necessarily need a Power BI Pro license. You can achieve this with the free version of Power BI Desktop.However, if you plan to share reports or dashboards with others, you’ll need aPower BI Pro license for publishing and collaboration.

Below is the link will help you:

Use Power BI Desktop to connect with your Project data - Microsoft Support

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.