Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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)
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
101 | |
74 | |
70 | |
47 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |