cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
arielfmdp Frequent Visitor
Frequent Visitor

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.

2 REPLIES 2
Super User
Super User

Re: Get JSON data on report view, from link on column

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)

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Community Support Team
Community Support Team

Re: Get JSON data on report view, from link on column

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