Forum Discussion
Getting a table from a Json text response url with PowerBi Desktop API
I am new to PowerBi and would like to receive a table from a JSON URL: * the url is : Data from API * sample data looks like this (one formatted-not with PowerBi): {"data": [ {"user_id":...
Tx a lot for the help, got it working tx to you, and thank for teaching me this blank call.
Best
working code is slithly different, I guess API call changed:
```
= Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"user_id", "hp_user_id", "username", "user_profile_url", "user_blocked", "hp_post_id", "post_datetime", "post_url", "post_summary", "me_too", "post_tags"}, {"user_id", "hp_user_id", "username", "user_profile_url", "user_blocked", "hp_post_id", "post_datetime", "post_url", "post_summary", "me_too", "post_tags"})
```