cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
XaviOV
Helper V
Helper V

Keep points when running get data

Hi,


When I run Get Data from Excel online, numbers that have decimals with "." (point), delete the point.

How can I solve this problem?


Thank you!

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi @XaviOV , 

I think this should be related to your language. When you load the Excel in powerbi, this will convert type to numberic type and your language will use "."  as thousand separator, ","  as demical separator. so it ("." )will disappear. You could view to my image(I use English(US) language, I have the opposite situation ) 

626.PNG

 You could try to change type like below to see whether it work or not

627.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
dax
Community Support
Community Support

Hi @XaviOV , 

I am not clear about your requirement, if you remove the "point", the value will change. If possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

I attach a couple of images, the original data in Excel and the data before uploading it to Power BI.

Regards,

Xavi

 

https://ibb.co/jW74Syt

https://ibb.co/mTccLdD

edhans
Super User III
Super User III

Can you clarify what you are seeing @XaviOV ? Excel Online doesn't have a Get Data function. And spreadsheets generated or edited in Excel Online are just XLSX files, nothing unique about them.

 

And when you say the decimal is removed, is 123.45 becoming 123 or 12345?



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi @edhans 

I attach a couple of images, the original data in Excel and the data before uploading it to Power BI.

Regards,

Xavi

 

https://ibb.co/jW74Syt

https://ibb.co/mTccLdD

edhans
Super User III
Super User III

I cannot really tell what you are referring to here @XaviOV - I don't know which is the before or after image. You can post images in this forum using the Camera icon. Please use that and describe what each image is.

 

And what do you mean "upload to power bi?" Is this in the service, or when importing via Power BI Desktop? Please let us know the exact steps you are going through to get the results you are seeing.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi @edhans ,

 

Attached images with explanation.
Regards,

Xavi

This is the Excel file (local), and the numbers contain "." decimals.
Excel file (local file)Excel file (local file)

This is when I upload the Excel file into Power BI, you can look that the "point" are disappear.
Power BIPower BI

dax
Community Support
Community Support

Hi @XaviOV , 

I think this should be related to your language. When you load the Excel in powerbi, this will convert type to numberic type and your language will use "."  as thousand separator, ","  as demical separator. so it ("." )will disappear. You could view to my image(I use English(US) language, I have the opposite situation ) 

626.PNG

 You could try to change type like below to see whether it work or not

627.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@dax  solved, thanks !!

edhans
Super User III
Super User III

Are you sure those are numbers? They are left-aligned, and that usually means it is text.

Can you show what it looks like in Power Query once you hit Transform, and the M code that is being generated (Advanced Editor) for the query. I really want to see the "Changed Type" step.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Greg_Deckler
Super User IV
Super User IV

Is it switching it to Whole Number versus Decimal Number? Check your Change Type steps.

 

Otherwise

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors