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
Post a Comment