MS Project OData connection showing Null on Enterprise Task Level Custom Field

[Find2022]

Hi All, 

I have created Enterprise task level custom field - connected to Text based lookup table. 

When connecting to Project Online - using OData, all the columns under the Custom field are showing up as null, snapshot below: 

What can I do to read the data into powerbi? Any troubleshooting tips as well? 

[YusraLohano]

Anyone able to find a solution to this one yet?

[v-eqin-msft]

Hi @Find2022 ,

The account you use to connect to the OData feed must have at least Portfolio Viewer access to the Project Web App site.

Did such issue occur in Power BI Desktop or Power BI service?

For references:

Power BI - Connecting to Project Online - Hat Full of Data

Project Online: connect to data through Power BI Desktop

Connect to Project Online with Power BI

Best Regards,
Eyelyn Qin

[Find2022]

Hi Evelyn9,  

Thanks a lot for the links. Yes I could access the rest of the data such as tasks, start date, end date etc. But the issue is with columns that was created based on custom fields - these fields were created with lookup table to it at task level or also open text. The text was not imported into powerbi. 

Tried both on powerbi service and powerbi desktop.. 

Any ideas how to resolve the custom field? 

Thank you!