Using Project Online as a data source - fields missing in BI

[nogi]

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.

[v-shex-msft · Accepted solution]

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]

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

[WH23]

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