Forum Discussion
Thousands separator issue when refresh
I've created my powerbi desktop model and I've published it without problem. I've also connected the same using a gateway in order to schedule refresh, but here comes the issue. When I publish the model, it works,but when I have the same refreshed automatically comes the issue. No error into completing the process but the data are wrong as it gets somehow broken the thousands and decimal separator that, when I publish the model, were ok.
Last time i've got this issue I was loading currency exchange (RMB to EUR) which is 7.66 (written as 7,66 according to the Italian std): when I publish (push the update) I can see it correctly at 7.66 but when I get the report refreshed as for schedule, it gets broken and goes to 76000.00, and this way any calculation gets broken.
this is not the first time I've got this issue, but this is becoming annoying and much important, force me not to share and use my report
10 Replies
Difficult to advise without seeing your Power Query code. Are you specifying the input locale?
Well, the power query code is easy to be shared and the outcome of the same (the column rate) is actually the problem.
As said, it shows the right formatting on the desktop version, gets broken when the powerbi service run the scheduled refresh.
I've downloaded the file from the powerbiAPP and it gives me this wierd situation: the power query keep the right format but when I look at the same query in the Table view this format gets lost and spread this error to the model"Customer Sales Distr" is of type "any". Don't do that. You are also missing the locale.
