You are currently reviewing an older revision of this page.
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 se to type text you won't be able to summerise 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.