PowerBI Pro - Custom / Enterprise fields in O365 Project Online datasets

How to report on Custom / Enterprise fields in PowerBI Pro!

Step 1 - Connect to Project Online with PowerBI
https://docs.microsoft.com/en-us/power-bi/service-connect-to-project-online

Step 2 - Open / Create a report

Step 3 - Within the fields tab, right click on the Project table and edit query


Step 3 - The power query editor will open, within the queries tab, right click on Projects and open in advanced editor

Step 4 - You will see the #"Removed Other Columns". Dont let the name fool you, its actually a white list of the fields which are available in the dataset, so scroll to the right of all the fields and add in quotes "<name of my enterprise field>"


Comments

Popular Posts