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 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'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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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