Skip to main content



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
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>"

Latest Posts

SharePoint 2016 / 2019 install in German / Deutsch on Windows Server 2016 in German

Powershell firewall ports for SharePoint 2010 / 2013 / 2016 / 2019

SharePoint 2013 One Drive Issues

SharePoint 2013 Blank login page and other login issues

SharePoint 2010 / 2013 CAML In / Include Function