cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasDay Established Member
Established Member

Query: Change type to "decimal" from "whole" and reload?

I realize that a few thousand of the 20mm in one data table require a decimal format while the rest are whole numbers ($).  Clearly I can change the type of that column from integer to decimal in the query, but I really don't know if that's going to ruin the database.

 

I can make a copy and try it, I suppose...but even if things seem right, does anyone know whether it's "not a problem" or at least shouldn't be.

 

Thank you,

Tom

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Query: Change type to "decimal" from "whole" and reload?

You should set the data type on import in the Query Editor.  Changing it after the fact wont break anything, but you will need to do it in the Edit Query window so it brings the data back in in the new format.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
2 REPLIES 2
Super User
Super User

Re: Query: Change type to "decimal" from "whole" and reload?

You should set the data type on import in the Query Editor.  Changing it after the fact wont break anything, but you will need to do it in the Edit Query window so it brings the data back in in the new format.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
ThomasDay Established Member
Established Member

Re: Query: Change type to "decimal" from "whole" and reload?

Thanks Matt...you've been a big help as I get started with Power.bi.  

Tom  

PS: I just bought your book.  You're clearly a big DAX resource and it is fun to learn from those that have really mastered this platform (all those that have helped me out, for example).  It also gets very nice reviews and comes in every conceivable format.