Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a table with a column containing the services I need to call to retrieve some other data, which needs to be modified with other further steps once I can return the records from these services.
Meaning I need to execute these services and report the returned values in some other columns.
How can I do it?
Thanks
Simone
Solved! Go to Solution.
@sceccolini
Can you use below query in a blank query and paste any one of the URL and let me know what you see?
let
Source =Json.Document(Web.Contents("URL"))
in
Source
Or use the below file and let me know.
Hi @sceccolini
Can you provide sample output you are looking for(Sample data inside one of the URL and what you need to pick and bring it to the new column)? it will be easy to understand the requirement.
Thanks,
NG
Hi Naveen,
thanks for the reply. This is an extract of the properties returned by each service in the column
Of course, tthe REST invocations are always on the same service, which returnes the same properties; each service will just change the values of the returned properties. Among the above properties, we will need some of them, which will be configured as dedicated columns.
Thanks
Simone
@sceccolini
I have used a sample API to create a POC(This has JSON in multiple rows, so the end table will expand, It might not be the case with you).
If the first step works fine(JSON expansion), then the remaining can be tweaked depending on your format.
Attached file here has the POC.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
@sceccolini
Can you use below query in a blank query and paste any one of the URL and let me know what you see?
let
Source =Json.Document(Web.Contents("URL"))
in
Source
Or use the below file and let me know.
It works! I can just add a new custom column with this formula, and then I can manage it like any other transformation. Thank you!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
68 | |
54 | |
37 | |
35 |
User | Count |
---|---|
66 | |
66 | |
59 | |
53 | |
45 |