Forum Discussion

nogi's avatar
nogi
Advocate II
8 years ago
Solved

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

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 d...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
nogi
Advocate II
8 years ago

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

WH23's avatar
WH23
Frequent Visitor
8 years ago

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