Data in Chinese Characters Displayed as '???' on PBI Service

[Lilylv]

Hi All,

I have a pbix file in which there is one column shows both the english name and the chinese name of cutomers(datasource is sql server). Before it displayed well in english and simplified chinese on Power BI Service, but from last week, it occasionally shows '???' for those chinese characters.

The only thing I've adjusted for this file recently is changed a gateway for refreshing the datasource online. What's more, when encouterred this issue, I checked the datasource in sql server, there's no outstandings or specific formats, then I tried to change back the old gateway, but stilll it sometimes dispalyed correctly and sometimes incorrectly.

Does any one know why it happens?

Thanks!

[Anonymous]

Did you get any solution around this? I am facing the same issue

[v-deddai1-msft]

Hi @Lilylv ,

I really can't reproduce your issue. Would you please check the data type of your chinese column in sql server? Is it varchar instead of nvarchar? Please change it to nvarchar and try again.

What's your browser? Would you please check the language setting of your browser? Please refer to https://www.computerhope.com/issues/ch001904.htm

Best Regards,

Dedmon Dai

[Lilylv]

Thanks for the suggestion, I've tried to change the default language of the browser(Google Chrome), still have this issue. And the data format in SQL is correct.

Which really wierd is that this morning when I refreshed the data, it's displayed in Chinese! But few hours later when I refreshed again, it failed to dispaly well...