Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Data Difference Between Desktop and Service

I'm using data import from Azure SQL server and have decimal numbers stored as text.

in Power Query i'm converting the text to number and then created measures based on these fields.

While using desktop edition everything works great but when refreshing the dataset on service it eliminates the dot as decimal seperator converting it to whole numbers, 0.44 become 44.


i found a workaround, not converting the text to number in Power Query but in Power BI and it works. but now i need to aggregate the data in Power Query so the workaround is not useful.

would appreciate any idea on how to approach this.

Regular Visitor

Actually the solution was very simple. 
it appears that my locale was set on English (Europe) where the dots represents thousands and not decimals. 
i needed to change the setting on my PBIX to English (United States) and republish the report.

Community Support
Community Support

Hi @AsafPinhas 

1.Perhaps you can try to convert the type on the database side now.

2.You can aggregate the data in Power Query first, then create a calculated column to quate these data, then set the type of the calculated column.


Best Regards!

Yolo Zhu

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors