Custom RAG Column in MSP but Null Value in Power Query Editor

[MO14STA]

Hi All

I haven't been able to find an answer regarding this issue anywhere but apologies if this has been resolved elsewhere and I would appreciate if you can point me in the right direction. 

I have a custom RAG column in an MS Project Template which returns Null Value in Power Query Editor, when trying to create a dashboard visual based on this and other columns. Is it relating to the formatting of the column as it's set to appear as a circle symbol with respective colour of the RAG from the dropdown list?

 

[Payeras_BI]

Hi @MO14STA ,

You can always re-create the logic behind that RAG column in Power Query with a conditional column since it looks like what you are looking for is not possible according to this:
Solved: Custom Column from MS Project in Power BI Desktop - Microsoft Fabric Community

[MO14STA]

If I was to recreate the logic in Power Query, I would have to manually update the rows with the RAG Status? Not an ideal workaround

I have other custom columns in my Project Template that are pulling through into PowerBI, albeit some with the true values and other with Null Values also