Forum Discussion
Conect Power BI to Microsoft Project.
Good morning everyone, I have a problem with connecting Power BI to the Microsoft Project service. I have an Enterprise 365 subscription and a subscription to both desktop versions. I am trying them all and I cannot read a job done with Microsf Projec on power BI.
I have also tried in the web environment to connect power with Microsoft Project Web App and Microsoft Project for wen, with the same negative result. I am attaching the images of the message. I thank if anyone would like to help me
Ragnatela:
6 Replies
- Poojara_D12
Super User
Hi Shezan
To connect Power BI to Microsoft Project:
- Permissions: Ensure your Power BI account has the right access to Microsoft Project or Dataverse.
- Correct Connector:
- For Project for the Web, use the Dataverse connector.
- For Project Online (Web App), use the OData Feed connector.
- Connection Settings: Make sure you're using the correct URL for your environment or Project Online instance.
- Authentication: Ensure you're signed in with your Microsoft 365 account and have the necessary permissions.
- Check Service Health: Verify there are no issues with Microsoft services.
If you're still facing issues, provide error messages for more targeted help.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS- Authentication: make sure you are logged in with your Microsoft 365 account and have the necessary permissions.
What permissions are needed?
- Authentication: make sure you are logged in with your Microsoft 365 account and have the necessary permissions.
Hi, I would like to connect the database to this job which is in MS Project 365 web space- I tried this address but it does not recognize my credentials. I report that I have logged into MS 365 and use all the rest of the functionality. Is it possible to do this? I am not an expert, thank you
"Authentication: Ensure you're signed in with your Microsoft 365 account and have the necessary permissions."
Thanks for your help but how do I verify the correct permissions on office 365? Many people write me this verification but I don't know how to do it. again I have corporate acount and it seems to work in everything except for this power BI and project connection. Also the connectors are correct and my profile seems to be authorized and recognized but in the end it comes up with the errors I reported in my first post. I thank you but your directions are very general and I find them written all over the place.
Hi, Shezan
Thank you very much for popping up on the Fabric forums and asking questions. I can understand your urgent need to connect to MS project.
Have you consulted these two articles to see if they fit you?Solved: Connecting Power BI to Project for the Web - Microsoft Fabric Community
Visualize Microsoft Project Data in Power BI using xViz Gantt Chart
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Shezan ,
When connecting to Project Online data through Power BI Desktop. If the address for your Project Web App site resembles https://<tenantname>.sharepoint.com/sites/pwa, then the address to enter for your OData Feed is https://<tenantname>.sharepoint.com/sites/pwa/_api/Projectdata.
Power BI Desktop prompts you to authenticate with your work or school account. Select Organizational account and then enter your credentials. The account you use to connect to the OData feed must have at least Portfolio Viewer access to the Project Web App site.
When connecting to the Project Web App using Power BI. For Authentication Method, select oAuth2 > Sign In. When prompted, enter your Project Web App credentials and follow the authentication process. You need to have Portfolio Viewer, Portfolio Manager, or Administrator permissions for the Project Web App you are connecting to.
Detailed information is available in the documentation.Project Online: connect to data through Power BI Desktop - Power BI | Microsoft Learn
Connect to Project Online with Power BI - Power BI | Microsoft Learn
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
