Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Dears,
Below is my function in Power Query Editor. The output is currently as a table with a single row single column.
I need the function output to be a text in order to use its value. Please help
()=> let
url = "https://abc.track.com/api/v1/auth/login",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username="MyAbc",
password= "554433", fcmToken="456"]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
access_token=Json.Document(response),
result = access_token[result],
#"Converted to Table" = Record.ToTable(result),
#"Transposed Table" = Table.Transpose(#"Converted to Table"),
#"Removed Columns" = Table.RemoveColumns(#"Transposed Table",{"Column1", "Column2", "Column3", "Column4", "Column5", "Column7", "Column8", "Column9", "Column10", "Column11"}),
#"Removed Top Rows" = Table.Skip(#"Removed Columns",1)
in
#"Removed Top Rows"
()=> let
url = "https://abc.track.com/api/v1/auth/login",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username="MyAbc",
password= "554433", fcmToken="456"]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
access_token=Json.Document(response),
result = access_token[result],
#"Converted to Table" = Record.ToTable(result),
#"Transposed Table" = Table.Transpose(#"Converted to Table")
in
#"Transposed Table"[Column6]{0}
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.