Enterprise Fields - Lookup Tables RRS feed

  • Question

  • Hi Project Server People...

    Is there a way to expose lookup tables using ODATA

    I use Power BI to do loads of reporting from our Project Server Online system using ODATA as a feed however it only exposes main tables (projects, assignments, tasks, resources etc.).

    I wondered if there was a way to connect to lookup tables (defined through "Enterprise Custom Fields and Lookup Tables") and drag them in using ODATA?

    Tuesday, April 24, 2018 10:48 AM

All replies

  • Hi,

    No there is no way to expose the configuration by itself through Odata. There being said, if all the values of the lookup table are used, you can display the custom field linked to the lookup table in a slider in PowerBI and you'll have the lookup table values.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, April 24, 2018 12:02 PM
  • Yes - I'd thought of that thanks...problem is (as you said) not all the values are necessarily in use.
    Tuesday, April 24, 2018 12:33 PM