Solved: Re: Using Project Online as a data source - fields...

nogi · ‎09-26-2017

I have Power BI via our 365 Business subscription. We also have Project Online which I need to build some dashboards for. I have Power BI talking to PWA fine and data is being pulled through but it doesn't seem to be pulling all the data across. For example, any custom (enterprise) text fields are not showing in Power BI.

Needing some assistance in trying to work out what I have done wrong please.

Anonymous · ‎09-28-2017

Hi @nogi,

Based on test, project online connector seems not import these custom fields to power bi. In my opinion, I'd like to suggest you contact that team to know more about this connector.

BTW, when I try to use odata to connect project online at power bi desktop, my test column appears.

Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎09-28-2017

Hi @nogi,

Based on test, project online connector seems not import these custom fields to power bi. In my opinion, I'd like to suggest you contact that team to know more about this connector.

BTW, when I try to use odata to connect project online at power bi desktop, my test column appears.

Regards,

Xiaoxin Sheng

nogi · ‎09-28-2017

Yes, I ended up using ODATA and it all comes through now.

WH23 · ‎06-29-2018

Can I ask how you were able to import ODATA through. I've tried using the url (https://<sitename>.sharepoint.com/sites/pwa/_api/); however my custom fields are still not showing. I'm using Power BI online