Forum Discussion
Help needed with data source in power query
Hi Sookz ,
Are you referring to the fact that decimal in Excel goes into Power BI and displays as number?
You can do this in Power Query by selecting Columns - Transform - Data type - this will convert the data type of those columns to decimal, making sure to keep the decimal values.
Refer to:
Solved: Re: Power Query lost decimal values in numbers - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Liu Yang,
Thanks for your reply!
Yes, the decimal display in excel goes into Power BI and becomes a whole number. When the data is loaded, the data type is fixed decimal number but the data is not showing the decimals.
When i tried to change the format to decimal number, it shows whole number instead.
Note: This only happens when the data source is updated and refreshed in power query. If i re-load the updated data set as a fresh new data source, i don't encounter this issue.
I looked through the link that you shared and it was mentioned that type change should be done using M code in the advanced editor. I realised the the data type is currency instead of decimal/fixed decimal/whole number.
Tried changing the data type in M code in advanced editor to decimal and i get the same result (data turns into whole number and the decimals becomes .00)
Regards,
Sherry Cheong