cancel
Showing results for 
Search instead for 
Did you mean: 
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.



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors