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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
HUEyoung
New Member

how can i get record value raw text?

let
source = Json.Document(File.Contents("text.json")),
tabled = Table.FromRecords({source})
in
tabled

 

so this query shows

 

a.            b.          c.   

value.     List.        Record

 

i want show :

 

a.           b           c.    

value.    [a,b,c].    [{a : 4, b : 5, c :6}, [a : 5, b : 7, c :7}]

 

i can List show, but i cant show Record like this.

 

what can i do? 

 

before json to table, extract object raw string first? 

 

i cant find function. help !!

4 REPLIES 4
wdx223_Daniel
Super User
Super User

hope this can help

wdx223_Daniel_0-1664417847823.png

 

ty but i need load json, not string

could you please provide some sample data?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.