Skip to main content
cancel
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
Anonymous
Not applicable

Issue in data refresh: Decimals numbers change when a refresh is done

Hello,

 

I am stucked is a strange issue when I refresh my data. I am having a report which takes data from excel spreadsheets which are located in a sharefolder. When I am refreshing the report in my laptop (Power BI 64 bit) it refreshes properly without changing any data. However, when I am trying to refresh it from another PC with (Power BI 32 bit) my some of my data change by moving the decimals two steps right (i.e. if I have 10.01 it changes to 1001) and this obviously ruins my report's results.

 

Please note that this issue comes only from the one of the five excel spreadsheets that I use as a data source and I am struggling to find what is wrong with the data coming from this file and why in my laptop is refreshing properly and in the other PC it does not. 

 

Can you please support on this?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous 
I would check more/other machines.

Check if the locale is different between the 2 machines.

I dont think it is your data, I think it is the client machines are set differently.

Good luck!

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous 
I would check more/other machines.

Check if the locale is different between the 2 machines.

I dont think it is your data, I think it is the client machines are set differently.

Good luck!

Anonymous
Not applicable

Hello AClerk,

 

It is the locale indeed. I changes in from File/Options and settings/Options/Regional Settings. They had the same region but for some reason it was not working on the client's machine, thus I changed to English (United Kingdom) and it worked.

 

Many thanks.

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.