Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
asamr
Helper I
Helper I

Power Query - SQL - JSON Array - Read Æ Ø Å

Dear Community,

 

let
    Source = MySQL.Database("77.247.69.170", "concierge_admin_prod", [ReturnSingleDatabase=true]),
    concierge_admin_prod_products = Source{[Schema="concierge_admin_prod",Item="products"]}[Data]
in
    concierge_admin_prod_products

 

I have this Json String "Title" from an SQL Table.

 

Firstly I want to "import" this as Json and afterward I can convert it to a table through PowerQuery.

 

Secondly I want to be able to read the Æ Ø Å because as you can see in the screenshot, I am not able to.

 

asamr_0-1657084325376.png

 

Is anyone able to solve this?

 

1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

Hi @asamr ,
you can add a column with this formula: Json.Document([title])
This will parse the JSON string and return a record in each row that you can then expand as additional table columns.
For the umlauts, you can try to use a "replacements table" like described here: Multiple replacements or translations in Power BI and Power Query – The BIccountant

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

2 REPLIES 2
pfarias
Helper I
Helper I

Changing the record of the MySQL function, try to use ENCODING = 65001. I believe that would solve it.

 

 

let
    Source = MySQL.Database("77.247.69.170", "concierge_admin_prod", [ReturnSingleDatabase=true, Encoding=65001]),
    concierge_admin_prod_products = Source{[Schema="concierge_admin_prod",Item="products"]}[Data]
in
    concierge_admin_prod_products

 

 

MySQL.Database - PowerQuery M | Microsoft Docs

ImkeF
Super User
Super User

Hi @asamr ,
you can add a column with this formula: Json.Document([title])
This will parse the JSON string and return a record in each row that you can then expand as additional table columns.
For the umlauts, you can try to use a "replacements table" like described here: Multiple replacements or translations in Power BI and Power Query – The BIccountant

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors