In MemSQL we have data in UTF-8 , Can Power BI consume it?

[ZikoPowerBI]

Can we fetch data from MemSQL which is encoded in UTF-8

[lbendlin · Accepted solution]

yes, Power BI supports all usual encodings, and works with UCS2  Unicode in the background.

You can indicate the encoding during import.

[Anonymous · Accepted solution]

Hi  @ZikoPowerBI ,

On October 27, 2020, MemSQL was renamed SingleStore. This is how Power bi connects to SingleStore:

https://www.singlestore.com/blog/revolution/

https://archived.docs.singlestore.com/v7.1/third-party-integrations/connecting-to-powerbi/

For data in UTF-8 encoding format, Power BI is supported, and Power bi can also use M language to convert the imported data into "UTF-8" encoding format.

TextEncoding.Utf8

https://community.powerbi.com/t5/Desktop/Making-result-come-in-UTF-8/m-p/873316

https://docs.microsoft.com/en-us/powerquery-m/textencoding-utf8

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

yes, Power BI supports all usual encodings, and works with UCS2  Unicode in the background.

You can indicate the encoding during import.