Forum Discussion
Helper IIIn MemSQL we have data in UTF-8 , Can Power BI consume it?
Can we fetch data from MemSQL which is encoded in UTF-8
yes, Power BI supports all usual encodings, and works with UCS2 Unicode in the background.
You can indicate the encoding during import.
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.Utf8https://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.
2 Replies
- lbendlin
Super User
yes, Power BI supports all usual encodings, and works with UCS2 Unicode in the background.
You can indicate the encoding during import.
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.Utf8https://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.