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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

PowerBI Service - Refreshing the data via Service displays extra zeros

Hello everyone! I have an issue regarding refreshing the data via PowerBI service. I have built a report for a client, getting the data via Azure Blob Storage. The data in Power BI desktop displays correctly, please check below.

 

Danut67_0-1627914232440.png

 

However, the data once it is refreshed in the Service, it displays extra zeros, please find a screenshot below.

 

Danut67_1-1627914262572.png

Does anyone know how I can solve this issue? I have tried changing the data type/format , changing the data source ( switching to csv / json files) but with no success. Moreover, I find it weird that some whole number columns such as clicks and visits are displaying correctly in the service while other whole number columns are displaying incorrectly e.g. deliveries. 

 

I am looking forward to hearing your suggestions and solutions. Thank you and have a great day!

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Anonymous 

 

I would suggest that there is something going on with either your data source or filters that are causing this.

 

If it was me I would look into this, because once that is fixed everything else would drop into place?





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

Proud to be a Super User!







Power BI Blog

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hey @GilbertQ! I have stripped away all the filters and the data is still wrong. This means that the interaction between the data source and the Power BI Service refresh is messing up the tabels. I will try to change the data source and see if that works. Thank you very much for your time! 

Anonymous
Not applicable

Danut67,

Mycyberscore still says I am delinquint in my training and I took the training over a month ago.  The lag in reporting is frustrating because it goes to my regional boss.  I have to go into my training records to prove I took the training a month ago.  I don't see why we have a mycyberscore if it is not a good representaion of what I am actually doing.

Thanks for letting us know.





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

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @Anonymous 

 

I would suggest that there is something going on with either your data source or filters that are causing this.

 

If it was me I would look into this, because once that is fixed everything else would drop into place?





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

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @Anonymous 

 

That is really weird.


What happens if you create a measure, does that display the values correctly?

 

It not what happens if you create a measure and divide it by the number of extra zeros and see if that solves your issue?





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

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hey @GilbertQ !

 

Thank you very much for the suggestion. Some measures are displaying correctly, while some of the are very skewed (due to the fact that some columns have the extra zeros). I have created a new measure to display the marketing investment using FORMAT and DIVIDE to eliminate the extra zeros and that has helped. However, I have noticed some big irregularities in the data set that I do not understand at all. Please see a snippet below.

 

Danut67_0-1627986592634.png

 

The expected value would be 10.5 M, definitely not the value that shows up in there. 😁

 

This leads me to belive that there is an issue with the underlying data but, I do not seem to encounter this issue in Power BI Desktop which confuses me a lot.

 

I believe that the zeros issue can be solved by creating measures but I still do not understand why my data changes so much after the refresh in Power BI Service 🤔

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.