Thai character change to ?????? after refresh dataset via app.powerbi.

[j2k6a9]

Hi Guys

I have trobule with power bi about Thai language after schedule refreshed.

I created power bi report and link with Azure SQL Db. SQL Database collation is THAI_CI_AS

Data show in Power Bi Desktop is perfect and fine. When I publish report to App.powerbi it still fine but when power bi schedule update run all my Thai character change to ??????. I download pbix file all dataset contain thai character change to ?????.

Before dataset refreshAfter dataset refresh

I try to change Regional Settings to Thai (Thailand) but it not working.

I try to search but not get any case like this.

[v-shex-msft]

Hi @j2k6a9,

Maybe you can try to change power bi service language or download thai version of power bi desktop and try again.

In addition, you can also submit a support ticket for report this issue.

Submit a support ticket

Regards,
Xiaoxin Sheng

[j2k6a9]

Hi @v-shex-msft

I try this function before but it didn't work. 

Thank you for your reply.

[Anonymous]

Does the gateway server need to have this language pack or some additional settings? I would give this a try.

[j2k6a9]

Hi @Anonymous

Power Bi can direct link to Azure SQL Db. with Data source credentials setup. I didn't use powerbi gateway.
And In Azure SQL Db not any option to set about language pack I can set only Db collation.

Thank you for your help and reply

[Anonymous]

I see that you are referring to Azure sql. I am not exactly sure what to do in your case. 

Are you able to change the collation in the query. 

https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support

Use the collation in the quer to return the expected results. 

Another item to test is to see if you can write a query to return the collation and display in simple result in a grid. This might be a few different things to try to find out when the data refreshes what the response coming from the Power BI service vs. Power BI Desktop client.

[j2k6a9 · Accepted solution]

Hi @Anonymous

Thank you for your kidnly help and find the solution. I just got the solution.

I change data type in dataset from text to use locale... in each field will contain my Thai character.

And it work perfect after refresh data from app.powrebi to azure sql db.