Forum Discussion
Anonymous
7 years agoNot applicable
Decimal Type Join Columns in Modeling
Hi All, In our project, we are using decimal(not fixed decimal) type Key columns for creating the relationship between dimensions and facts when we do modeling. do we face any problems if we ...
Anonymous
7 years agoNot applicable
The problem we are having in our case is, our key columns are drive keys, means it is a combinition of multiple columns, when we are derive these drive keys, their size is more than the normal whole number(bigint in sql server), to accomadate the same, we coverted all these drive key columns types to decimal number(not fixed decimal), which is equal to decimal(38,0) in sql server. We want to know the problems, we may face when we do like this.
v-diye-msft
7 years agoCommunity Support
Hi Anonymous ,
If you'd like to know the limitation when using decimal type in power bi model, here're blogs for yourreference:
https://www.sqlbi.com/articles/understanding-numeric-data-type-conversions-in-dax/
https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=50
Best regards,
Dina Ye