Solved: decimal is not appearing while we upload excel fil...

sujith_291183 · ‎04-24-2024

Hi All,
I am facing the issue decimals are not capturing after upload to power query,change the changed type manually but its not working.
Can you please help.

watkinnc · ‎04-24-2024

Are you using an xls file?

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

sujith_291183 · ‎04-25-2024

Hi Watkincc,
now is woking change the file to xlsx.
thank you

watkinnc · ‎04-24-2024

Are you using an xls file?

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

dufoq3 · ‎04-24-2024

Could you provide some screenshots before and after and the code used for changed type as well as error?

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

sujith_291183 · ‎04-24-2024

Hi dufoq3,
Change the loacle still not working

dufoq3 · ‎04-24-2024

Hi @sujith_291183, have you tried changed type Using Locale (you have to delete previous changed type steps).

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

decimal is not appearing while we upload excel file to power query

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024