none
Power Query Lookup Field RRS feed

  • Question

  • I don't know how to power query lookup field directly to PWA, currently I exported the lookup field as excel file and pointed it to that file in that folder. Please advise.

    Nitaya Luu


    NLuu

    Tuesday, February 25, 2020 9:00 PM

Answers

  • You can use OData Feed with https://<<tentant>>.sharepoint.com/sites/<<pwasite>>/_api/ProjectServer/LookupTables('<<lookuptable guid>>')/Entries

    This will retrieve look up field entries to the Power BI query.

    Lookuptable GUID can be found by navigating the lookup field table  --> expand system identification data.

    "Mark as Answer" if this worked for you.


    Wednesday, February 26, 2020 6:09 AM

All replies

  • You can use OData Feed with https://<<tentant>>.sharepoint.com/sites/<<pwasite>>/_api/ProjectServer/LookupTables('<<lookuptable guid>>')/Entries

    This will retrieve look up field entries to the Power BI query.

    Lookuptable GUID can be found by navigating the lookup field table  --> expand system identification data.

    "Mark as Answer" if this worked for you.


    Wednesday, February 26, 2020 6:09 AM
  • Worked, thx.

    NLuu

    Wednesday, February 26, 2020 3:07 PM
  • Hi Mulali,

    https://xxx.sharepoint.com/sites/xxx/_api/ProjectServer/MYxxxGUID/Entries 

     "I got not valid" message, can you guide if I missed anything?

    Thank you,


    NLuu

    Thursday, September 10, 2020 4:11 PM