Correcting Data types


Wiki User Guides LMS
User Guide FAQ's Release Notes Microsoft Learn - PowerBI
1 - Cloud Parameters 2 - Project & Location Summary 3 - Starter Query Editing Reports Data Techniques
Installation Data Security Popup Resetting User Credentials
OpenGround API Documentation

When Power BI collects data from OpenGround for the first time, it makes a guess at the PowerBI data type that best represents the data. Unfortunately, this data type is not always right and may need correcting. For example, if a number has been incorrectly set to type text you won't be able to summarise the data for Max and Min values.

Follow the steps below to change the Data Type.

Once this change has been set using the interface, it is automatically scripted in the PowerQuery and so will be applied the next time data is collected from OpenGround.