Web JSON returns links as values

Question

Hi, everyone!&nbsp;I am loading a json from web and Power BI Desktop loads a table.Some of the columns have vaild fields (application id is 629 for example).However some columns (metadata) return a link.I can open this link as a new query and get the underlying data, but doing it for every row is a long process.I couldn't find any answers on the internet so far.Can anyone help please?Thanks!&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous,
You can refer the following links to get it:
Json Transformations
Convert Data from Power BI JSON to Table in 10 Easy Steps
Expanding Json list
If the above ones can't help you get the expected result, please provide the related JSON file or link and the applied codes in your Advanced Editor. Please note that exclude sensitive data before you share it with us. Thank you.

Best Regards

Forum Discussion

Web JSON returns links as values

1 Reply

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2

Create Measure to Return Highest Value