Forum Discussion
Format changes when refreshing in service
This was caused by a column without type in power query. I got the tip from the comment in this article: https://www.biinsight.com/resolving-format-cells-change-after-refreshing-data-sources-in-power-query/
Long story short, never forget to type every column returned by a query:
#"Added Conditional Column" = Table.AddColumn(#"Previous Step", "COLUMN", each if ..., type number)Best regards.
Community SupportHi Anonymous ,
This problem should be caused by different regions. You try to unify the language of Desktop and Service.
Supported languages and countries/regions for Power BI
For Desktop, maybe you can do like this:
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I´ve changed that option but it does not work.
Besides, I´ve always had the desktop language in English. And every report I have works fine, even the one with the problem, It´s only in that one tab where I played with the QA visual language. And more important, it only happens after a refresh.
I´m lost here...
This was caused by a column without type in power query. I got the tip from the comment in this article: https://www.biinsight.com/resolving-format-cells-change-after-refreshing-data-sources-in-power-query/
Long story short, never forget to type every column returned by a query:
#"Added Conditional Column" = Table.AddColumn(#"Previous Step", "COLUMN", each if ..., type number)Best regards.