Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 mo...
Dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

 

lbendlin's avatar
lbendlin
Super User
2 years ago

"Customer Sales Distr"  is of type "any".  Don't do that.  You are also missing the locale.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    how can another field which is not the issue, affect the outcome of rate?
    The issue isn't on that field.
    What do you mean by "missing the locale"? please be more specific

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Yes i'm working in Itatly so the standard are "," for decimal and "." for thousand.
        Anyway my jobs are done in English as we are a multinational company so the outcome is the contrary "," for thousands and "." for decimal