Forum Discussion
Get JSON data on report view, from link on column
Hi, I need to parse JSON data from a link showing in each row table, so when the user clicks the link the JSON data is retrieved and processed and shown live, in other different visual. The link returns directly a response in json format of course.
Is that possible ? or not yet ?
I didn't make anything up to now, so I don't have a report to show, but the thing is pretty simple I think: a table for example with two columns: name and link The user clicks one link and the data is loaded in another table or something.
If is not possible, it would be great to add it in some near future.
Best regards.
3 Replies
Not sure if I understand your request right, but I think you have to choose between these 2 options:
1) Load all possible links to the data model and use the JSON URL as a parameter
2) If you don't want to load all possible results in advance, you can use this technique to give the user the opportunity to select what should be loaded: https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/ . But then he has to refresh the data, so that the load will actually take place (so this is nothing that would work in the service)
i have a simular question:
a list of zipcodes an ther i can creae an url that gets te geodata for each zipcode.
like 9910, http://loc.geopunt.be/geolocation/location?q=9910
the URL gives a JSON result:{"LocationResult":[{"Municipality":"Aalter","Zipcode":null,"Thoroughfarename":null,"Housenumber":null,"ID":592,"FormattedAddress":"Aalter","Location":{"Lat_WGS84":51.095251068982691,"Lon_WGS84":3.4472705752524129,"X_Lambert72":85448.43,"Y_Lambert72":198749.56},"LocationType":"crab_gemeente","BoundingBox":{"LowerLeft":{"Lat_WGS84":51.015545069607555,"Lon_WGS84":3.3332263940958162,"X_Lambert72":77336.36,"Y_Lambert72":189988.5},"UpperRight":{"Lat_WGS84":51.160750961453168,"Lon_WGS84":3.52458407748664,"X_Lambert72":90946.9,"Y_Lambert72":205971.66}}}]}
I want to get data from each line ( another zipcode ) form the URL.
Do you understand my problem?
Would this be possible?Here is a sample of the data:
greetings
Christoph
Hi arielfmdp
I'm afraid it is not possible currently, you could submit your idea here.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards
Maggie
