Get JSON data on report view, from link on column

[arielfmdp]

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.

[v-juanli-msft]

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

[ImkeF]

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)

[ChriMoSW]

@ImkeF 

 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:

Postnummer	aantal	geocode
8000	212	http://loc.geopunt.be/geolocation/location?q=8000
8020	135	http://loc.geopunt.be/geolocation/location?q=8020
8200	171	http://loc.geopunt.be/geolocation/location?q=8200
8210	94	http://loc.geopunt.be/geolocation/location?q=8210
8211	26	http://loc.geopunt.be/geolocation/location?q=8211
8300	70	http://loc.geopunt.be/geolocation/location?q=8300
8301	41	http://loc.geopunt.be/geolocation/location?q=8301
8310	213	http://loc.geopunt.be/geolocation/location?q=8310
8340	69	http://loc.geopunt.be/geolocation/location?q=8340

greetings

Christoph