undefined

[Manjula]

My data source is a Oracle Database. When I change the data type of one of the column from text to date i get the following pop-up message box:

"With this data type change, your data will be stored differently. This may cause a loss of data or precision. After you make this change, you can restore the column by refreshing the table.

[v-angzheng-msft · Accepted solution]

Hi, @Manjula 

If you can change the value successfully and without error then you can ignore this warning.

But If the data type is supported, but there are values that are not supported within the new data type, you will get another error, and will need to correct the data values before proceeding.

The meaning of the second half of the statement "...., you can restore the column by refreshing the table"

it should be related to power bi data structure. The change data type operation will be applied a 'change data type' step to the backend query table then power bi will force update the data model table fields to sync the records structures.

This operation has not affected the raw data structure which cache in previous query table steps.
If you change back the data type and do refresh operations, power bi will re-generate the data model tables based on the backend query table structure and these data type meditation will be restored. ('restore the column by refreshing the table' mean the use refresh feature to re-generate the data model table with raw table structure)

refer:

Changing Data Type of a Column

For more information about data types, you can refer to the following documents

Set the data type of a column in Power Pivot

Data types in Power BI Desktop

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mussaenda]

Hi @Manjula ,

it is not an error, it is a warning that changing data type might cause data loss or precision.

[amitchandak]

@Manjula , This should be a warning. Should be fine, if there is no error in conversion.