Connecting Project site to power bi

[Archie-gh]

Hi, 

I need to connect project site in PWA to power bi, everything is oK and i am connecting them but the probelm is, it doesn't show all of columns which i created there. it only shows default column. for example, 

in risk section, there is risk mitigation column by default and being shown in power query, and I added another column next of risk mitigation column called risk rating, but it doess't show in power query the my new column. 

can anyone help me how I can connect any new column in project site to power bi?

[Archie-gh]

I think, reporting of custom column in power bi from project site is not easy, unfortunately I couldn't find any answer how I can connect new added custome column into power query. 

[Archie-gh]

I add columns in project site, but when I refresh the power query, they won't be shown 

[v-yiruan-msft]

Hi @Archie-gh ,

First, please make sure that the new added column risk rating  is displayed in the odata feed data source exactly. Please try to follow the steps in the following blog to clear the cache and check whether the new added column risk rating can be loaded successfully after completed the cache clearing...

How To Clear Cache Of Power BI Desktop?

Clear cache

Clear the cache of data source

Best Regards

[v-yiruan-msft]

Hi @Archie-gh ,

Where did you add the new column risk rating? In project site or Power Query Editor? Did you click "Refresh" in Power Query Editor after add the new column? Could you please provide the applied codes in your Advanced Editor if it is convenient? Please mask the sensitive info before share it with me. Thank you.

Refresh All

Advanced Editor

Best Regards