JSON from web parsing

[dalmar22]

Hi,

I am trying to get user tweets in json format to power bi using postman, data seem to load, however power bi doesn’t transform json into records or into table. When I paste it to json viewer it parses correctly.

Any advice what should I do to get json data into records/ table?

Thanks

[mahoneypat · Accepted solution]

Why not just make the web call straight from Power BI with Web.Contents("your url")?  That would be a simpler approach.

Pat

[dalmar22]

...aaaaand you are right

Thank you