Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
GianlucaM
Helper II
Helper II

wrong data formatting after refreshing dataset/dashboard

Hi All,

 

i've an issue when I refresh a dataset/dashboard: the format of a measure that sum the value of a column loose his format and trasform thousands in millions even if the model itself is right. 
Infact, when I publish the report for the first time it is perfect, if I connect the same to a gateway and aks for a refresh, the number get wrong format.

 

Thanks for helping

4 REPLIES 4
v-yetao1-msft
Community Support
Community Support

Hi  @GianlucaM 

What if you republish the report to the Service? Is the data displayed normal? If you do a refresh in Desktop, is the response normal? What is your data source?

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Yes the data is fine when I refresh it on desktop and is still fine when I publish the same. The issue came when I try to connect the data through a gateway and ask for a syncronization/update of the data.
Part of the measure go crazy and I think i'm loosing the right format of some data as thousands becames millions
what first is correct 

GianlucaM_0-1698839087058.png

than becomes incorrect

GianlucaM_1-1698839132752.png

What go crazy is the measure "forecast" which is a simply sum of a column which is made by data correctly formatted (as in the desktop version it is correct even in the graph)
the measure detail is this

Forecast qty = SUM(Forecast[Planned qty]).
This column is formatted like a decimal number where "," is the separator for thousands, and . is the separator for decimal as you can see by the screenshot
GianlucaM_2-1698839362485.png

Thanks for helping

G


https://app.powerbi.com/links/C9FsyERMnd?ctid=cab1b94c-6ab2-47be-969f-352d18a86be4&pbi_source=linkSh...


ibarrau
Super User
Super User

Hi. That's strange. I think you could try adjusting the format to the measure manually. Get in the power bi desktop and specify the format of the measure with a custom string that make sense for you. You can check this doc to read how it works:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

That should make sure you won't have an issue with millions, thousands or hundreds. Consider that decimal points are a different story that depends on the browser language on how it will show it (dots and commas)

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Hi, @ibarrau i've tried but this doesn't work as this issue comes not from the model but just when I ask to refresh the model.
the original file has "," as separator for the decimal and "." as separator for thousands (Italian standard). In my power bi desktop I have done the change to the international standard replacing "." with nothing and "," with "." in order to get clean data. Doing this it works perfectly in desktop but not when I push this to a refresh in the app service on line. Wondering how can I overcome this issue

Thanks

G

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors