Making result come in UTF-8

[efilipe]

Hello guys,

Can you suggest me what I can change to make the result come as UTF-8?

let
data = [ date_start = "2019-10-01",
date_end = "2019-12-31",
profiles= {"8282828282"},
fields= {"attachments", "author_id", "comments","created_time","id","interactions","likes","message","type","url","insights_engagement","insights_impressions","insights_reach","insights_saved","insights_video_views"}
],
header = [ #"Authorization"="Basic TWpBek9UiMDExYTcxOWRkOWMwZGIwYzAxYWI2NGViMDUz",
#"Content-Type"= "application/json; charset=utf-8"],
response = Web.Contents("https://api.socialbakers.com/1/instagram/profile/posts",[Content=Json.FromValue(data),Headers=header]),
out = Json.Document(response,1252),
data1 = out[data],
posts = data1[posts],
#"Converted to Table" = Table.FromList(posts, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"attachments", "author_id", "comments", "created_time", "id", "interactions", "likes", "message", "type", "url", "profile_id", "insights_engagement", "insights_impressions", "insights_reach", "insights_saved", "insights_video_views"}, {"Column1.attachments", "Column1.author_id", "Column1.comments", "Column1.created_time", "Column1.id", "Column1.interactions", "Column1.likes", "Column1.message", "Column1.type", "Column1.url", "Column1.profile_id", "Column1.insights_engagement", "Column1.insights_impressions", "Column1.insights_reach", "Column1.insights_saved", "Column1.insights_video_views"}),
#"Expanded Column1.attachments" = Table.ExpandListColumn(#"Expanded Column1", "Column1.attachments"),
#"Expanded Column1.attachments1" = Table.ExpandRecordColumn(#"Expanded Column1.attachments", "Column1.attachments", {"images", "videos"}, {"Column1.attachments.images", "Column1.attachments.videos"}),
#"Expanded Column1.attachments.videos" = Table.ExpandListColumn(#"Expanded Column1.attachments1", "Column1.attachments.videos"),
#"Expanded Column1.attachments.videos1" = Table.ExpandRecordColumn(#"Expanded Column1.attachments.videos", "Column1.attachments.videos", {"url"}, {"Column1.attachments.videos.url"}),
#"Expanded Column1.attachments.images" = Table.ExpandListColumn(#"Expanded Column1.attachments.videos1", "Column1.attachments.images"),
#"Expanded Column1.attachments.images1" = Table.ExpandRecordColumn(#"Expanded Column1.attachments.images", "Column1.attachments.images", {"url"}, {"Column1.attachments.images.url"})
in
#"Expanded Column1.attachments.images1"

Thanks!

[Anonymous]

This is what I did TextEncoding.Utf8([INTL Job Descriptions]) but I'm getting errors. Can anyone help? Thanks in advance!!!

[v-yuta-msft · Accepted solution]

@efilipe ,

You can use power query function

TextEncoding.Utf8

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

Community Support Team _ Jimmy Tao

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