How to connect project online into power bi

[vijay22kar]

Hi All, How to connect project online into power bi desktop

Please help

[Anonymous]

Hi,

I have another problem connecting. I get an error saying "Access to the resource is forbidden"

What does this mean?

[v-xicai]

Hi @vijay22kar ,

When you connect to Project Online data in an unauthorized account, the corresponding credential would be created. You may need to change credential as steps below.

1.In Power BI Desktop, click Data source settings.

2.Chose the Project Online data source, click Edit Permission option, or connect to Project Online again after clicking Clear Permission option.

Best Regards,

Amy

Community Support Team _ Amy

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

[vijay22kar]

Hi,

I'm trying this but showing below error.

[mwegener]

Hi @vijay22kar ,

does your URL look something like this?

https://xxx.sharepoint.com/sites/pwa/_api/projectdata/

[vijay22kar]

Yes

[vijay22kar]

like this : https://xxx.sharepoint.com/sites/pwa

[mwegener]

Please add: /_api/projectdata/ to your URL

Apply your credential settings on the root level https://xxx.sharepoint.com

[vijay22kar]

Hi @mwegener 

showing the same error.

[mwegener]

Hi @vijay22kar ,

could you share some screenshots from the connection setup and not from the data source settings?

[vijay22kar]

Hi @mwegener, Please check

[mwegener]

Hi @vijay22kar,

is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener · Accepted solution]

Hi @vijay22kar ,

maybe this will help.

https://pwmather.wordpress.com/2014/07/17/getting-started-with-projectonline-part-9-ps2013-office365...

...

The ODATA feed is permission controlled, to access this API the user will need “Access Project Server Reporting Service” – this should be granted via a Project Server security group / SharePoint security group depending on what permission mode your PWA instance is using.

...

[mwegener]

Hey @vijay22kar ,

check this out.

A fresh blog post on your topic.

https://hatfullofdata.blog/power-bi-connecting-to-project-online/

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[vijay22kar]

Thanks @mwegener,

I'm trying this but again showing below error. My company name & credentials are also correct.

[mwegener]

Hi @vijay22kar,

the error says that "The remote name could not be resolved."

Your URL appears to be invalid.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

Hi Vijay,

To connect online source into power bi, we need to use organizational account after that you need to sign in with the respective Email and password. it might be vary based on your source like some times you need use Micosoft account credentials, Rest API Tokens, Anonymus, etc..

[mwegener]

Hi @vijay22kar ,

check this out.

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

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[vijay22kar]

Hi, Thanks

I'm trying this but shown below error. please suggest

[mwegener]

Hi @vijay22kar,

that is this step.

Power BI Desktop will prompt you to authenticate with your Office 365 account. Select Organizational account and then enter your credentials.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[vijay22kar]

Hi @mwegener ,

I trying this again and again but shown the same error.