Published Report Multiplying a number?

[ptmuldoon]

I've notice a very strange behaviour in a Power BI report I have been working on, and wondering/hoping someone may have any idea on what is causing this issue.

In Desktop, I am comparing the current weeks AR vs prior month, and in Desktop this looks correct and agrees to my source data.

But that same report after I publish it to the Power BI Service is somehow multiplying those number by 10?   Those last digits on each number is the decimal that is not showing.

Has anyone seem something like before?  

EDIT.............  Well strangely after doing a full refresh of the desktop file, and then republishing the file to the Service, both numbers agree and are the same now.   Could a posssible bad upload have caused the earlier difference?

[Anonymous]

Hi @ptmuldoon ,

Based on the information you provided, you can do some error troubleshooting in these areas:

1. Sometimes, due to differences in data refresh status. If the data is not fully refreshed in Desktop prior to publishing, or if there are pending changes that have not been applied, this can lead to inconsistencies.
2. Ensure that any computation or data model transformations are consistent and properly configured. Differences in how calculations are handled in Desktop versus Services can lead to unexpected results.

If the suggestions above have not resolved your issue, can you provide more information:

• Please provide your Desktop version, data source type and connection mode.
• Whether the problem recurs when using other computers. Did this problem occur suddenly and did the same problem occur before that.

Best Regards,

Ada Wang

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

[ptmuldoon]

Ugh.  I had thought the full refresh last night in Desktop and republish fixed things.   But now this morning after a scheduled refresh on the Service, those same numbers are being multiplied by 10 again.    Its very strange as every looks correct, yet a refresh is causing an issue?

The desktop file is also getting bigger, currently over 100MB, so the file is using incremental refresh thus I can't easily see the data model on the Service.  But its just reading the same json files from sharepoint.