PowerBI Service - Refreshing the data via Service displays extra zeros

[Anonymous]

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.

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

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!

[Anonymous]

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]

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.

[GilbertQ]

Thanks for letting us know.

[GilbertQ · Accepted solution]

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?

[GilbertQ]

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?

[Anonymous]

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.

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 🤔