Skip to main content

Posts

Featured

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

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