Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Manjula
Helper I
Helper I

undefined

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.

 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

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
Super User
Super User

Hi @Manjula ,

 

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

amitchandak
Super User
Super User

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.