Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sujith_291183
New Member

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

‎04-24-2024 03:49 AM

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.

Labels:
Message 1 of 6
228 Views
0
1 ACCEPTED SOLUTION
watkinnc
Super User
Super User

‎04-24-2024 05:25 AM

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

Message 5 of 6
190 Views
0
5 REPLIES 5
sujith_291183
New Member

‎04-25-2024 12:48 AM

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

Message 6 of 6
162 Views
0
watkinnc
Super User
Super User

‎04-24-2024 05:25 AM

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!!
Message 5 of 6
191 Views
0
dufoq3
Super User
Super User

‎04-24-2024 05:09 AM

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.

Message 4 of 6
197 Views
0
sujith_291183
New Member

‎04-24-2024 04:19 AM

Hi dufoq3,
Change the loacle still not working

Message 3 of 6
207 Views
0
dufoq3
Super User
Super User

‎04-24-2024 03:58 AM

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

 

dufoq3_0-1713956284624.png

 


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

Message 2 of 6
219 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All