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.
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.