Forum Discussion
Reference table keeps rounding numbers
Hello, I have a referenced table that contains an age column. In the Source table the age column is decimal example: 49,9, While in the referenced table column Age shows 50. I have checked a...
Hello,
Thanks for the reply, I have figured it out.
It shows that when I load data from the PQ, automatically its rounding it up because I didn't set data type as Decimal in PQ before loading.
Do you have it set as an integer in Power BI? Can you provide a sample PBIX? I am not sure exactly the issue here. You are talking about a refrenced table, then a loaded table, so doesn't seem you are 100% in Power Query but also the data model, but your question isn't clear to me.